This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hello to all,
I wanted to know if it was possible to give the user the possibility to select the measures (like a filter system) to choose if he wants to include them in in a customized measure.
I have illustrated this in the example below.But I am not allowed to modify the structure of the table with the load editor.
I could have set this with a pivot but unfortunately I have one measure per column.
Do you have an idea, for example to play with variables ?
(if('$(vMeasure)'=1,num(Sum([Apple]),'0'))+ if('$(vMeasure1)'=1,num(Sum([Orange]),'0'))+ if('$(vMeasure2)'=1,num(Sum([Lemon]),'0')))
In my example the customized measure 'total sales' is adapted according to the selection 🙂
Selecting measures in qlik is not possible. However, you can perform a crosstable function in qlik (qlik's pivot table)
The issue is that you need at least 1 dimension to pivot on or else it wont work. But, here is what you can do.
I assume your load script looks something like this.
all you have to do is add a "dummy" field like this
'A' as dummy,
then perform this function on the table with the added string:
crosstable("Fruits" , "Values" , 1)
then you can load it a third time and remove the dummy column if you want. and you will be left with fruits and values.
that way the names of your measure columns become row values under the dimension fruits. and fruits can be selected.
Hope this helps.