Monthly Archives: février 2018
Cumul
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()))
Restrict contents of a list box
There are two ways (At least)
1. Use Calculated dimension or Expression in the listBox:
Create a new listbox, and choose 'Expression' from list of fields....
QlikView : Utilizing Calculation Conditions, Built in Custom Messaging and Help Text Functionality
Custom messages are useful for providing direction to users of a QlikView application. For example, the table chart below has quite a bit of...
Pop-up personnalisés
http://www.ecapitaladvisors.com/blog/qlikview-custom-pop-up-labels/
Let’s say I have a grouped chart with two expressions, Sales and Costs. I like the look of this chart, but there’s more information...
Format num en pourcentage %
num (Value,'#,##0.00%')
Insérer dans une variable
Select foo from table;
let variable = peek('foo',0,'tmp');
drop table tmp;
DATA:
Select baa from table where baa < $(variable);
Count all dans un script
tab1:
Load * from abc.csv;
Let a = NoOfRows('tab1');
Qlikview – Creating a Heat Map Using “ColorMix”
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...
Ignorer des erreurs dans qlikview
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...
Utilisation de la simulation
QlikView permet la mise en place de simulations dans ses applications. Une simulation est le fait de saisir une ou plusieurs valeurs dans un...