Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone!!! I want to filter for example 200 random codes in Qlik Sense. I have the list in excel. Do you have any idea how to do that easily?
THANKS!!!
You could use apply map on your dataload to flag the identified codes then either create a bookmark for them to select or present them with the filter on the screen. one click for the users doesn't get much easier.
I guess it depends what you mean by flexible.
Hello Sara,
you can make this solution more variable if you know before how many groups you like to create.
then you can give the user the posibility to change the number values in a excel file and read this as variables in your load script.
if(Code>=$(v_1) and Code<$(v_2), Group1,if(Code>=$(v_2) and Code<$(v_3),Group2 )) as Codegroup,
And to read a excel file as variable you can use the this:
Temp_Variables:
LOAD
Variable,
Value,
Description
FROM [lib://YourPath/Variables.xlsx]
(ooxml, embedded labels, table is Table1);
For a excel file that looks like
Variable Value Description
.... ...... ......
.... ...... ......
for i = 0 to NoOfRows('Temp_Variables')-1
let vName = peek('Variable',i,'Temp_Variables');
let vComment = peek('Description',i,'Temp_Variables');
let $(vName) = peek('Value',i,'Temp_Variables');
next i