Hello everyone,
I feel that this has been asked in some form or another, but the proposed solutions have not seemed to work for me. I have the Variable extension for Qlik Sense and the variable I am using is currently used to control the measure of a bar chart (by using a big IF statement and set analysis). However, I also want this variable to filter the data presented in a Table chart as well.
The example in pseudo-code would be this: IF(vVariable = 1, Field1 = values, IF(vVariable = 2, Field1 = values, etc.) Basically, I need the variable drop-down to act as if I am actually filtering values on the dimension.
I have tried using IF statements as both measures and dimensions in the Table, as well as trying to create further calculated dimensions in the load editor but nothing seems to be working. Any direct help or pointing me to discussions would be great. Thank you.
