Navigation triggered by a selection in a pull down menu

[Martijn1]

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.