Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm building a report in QlikSense. In this report I use a pull down menu which contains a couple of variables. Based on these variabels I get a different lay-out in my pivot table. So instead of creating multiple reports, I create 1 flexibel report.
See code/steps below. Based on what I see,this works fine.
Now my customer wants the bookmark menu in a pulldown menu. So, when u make a selection in the pull down menu, that u navigate to the correct report instead of using the bookmark button ór creating mulitple link buttons in the report.
Question: Is this possible and if so, how can i created that?
Code for creating a pull down menu which triggers a flexibel pivot table.
Code created in Editor mode:
KIES_WEERGAVE_M2:
LOAD * Inline
[_KiesWeergaveM2
Kring - Typologie - Adres,
Proces fase - Typologie - Groep m2,
Proces fase - Groep m2,
Proces fase - Categorie
];
Code based to created variabel in the report:
if(GetSelectedCount(_KiesWeergaveM2) <> 1, 'PTG',
IF(_KiesWeergaveM2 = 'Proces fase - Typologie - Groep m2', 'PTG',
IF(_KiesWeergaveM2 = 'Kring - Typologie - Adres', 'KTA',
IF(_KiesWeergaveM2 = 'Proces fase - Groep m2', 'PG',
IF(_KiesWeergaveM2 = 'Proces fase - Categorie', 'PC','PTG'
)))))
Code of the pivot tabel for creating 1 dimension
=if($(vWeergaveM2) = 'PTG', PND_Groep_Status,
if($(vWeergaveM2) = 'KTA', KRG_Kring,
if($(vWeergaveM2) = 'PG', PND_Groep_Status,
if($(vWeergaveM2) = 'PC', PND_Groep_Status,PND_Groep_Status))))
In my pull down menu I refer to the table created in the editor (1st step). By doing these steps, I prevent creating 3 extra reports. I just make 1 report flexibel. This works fine.