Tag: qlikview

Codes de couleurs (PBI utilise Hex #) - http://www.december.com/html/spec/colorcodes.html Aide à la détermination...

A Customer showed me this stacked bar chart and asked how to “make the Goals a different color”. What he really wanted...

Introduction This document shows you how to include arrows on charts to compare year on year data. This technique is useful to compare increase or decrease...

Hi there, i have a data set like below on a pivot table   Manager due day 0-15 16-30 31-45 45+ Total aa $27.557 $12.039 $4.978 $7.845 $52.419 bb $41.924 $32.955 $26.489 $59.119 $160.487 cc $0 $0 $0 $33.552 $33.552 dd $196.365 $97.496 $117.485 $251.297 $662.642 ee $73.342 $6.604 $2.215 $13.000 $95.161 ff $67.541 $36.390 $35.779 $437.480 $577.190 i'm trying to add a...

Dimension1: Month Dimension2: Year Measure: Eur_commission (amount)   I can calculate running total with 1 dimension only (month) using the formula:   Rangesum( Above(Sum(eur_commission), 0, RowNo()))  

num (Value,'#,##0.00%')

Select foo from table; let variable = peek('foo',0,'tmp'); drop table tmp; DATA: Select baa from table where baa < $(variable);

tab1: Load * from abc.csv; Let a = NoOfRows('tab1');  

Overview The colormix in Qlikview is a function that allows for different colors to be used in lieu of the default color scheme. As it...

Il est possible de dire à QlikView d'ignorer certaines erreurs lorsqu'on le désire. Pour ce faire, il suffit de mentionner l'instruction suivante avant le bout...