Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Nolan
Contributor III
Contributor III

Variable Extension: Toggling between measures

Hello everyone,

I am trying to recreate a sheet that a former colleague created, and am running into some issues. 

screenshot.png

 

Above is the basic layout of the sheet, and you can see in the top left corner you can toggle between Units and Sales, which in turn changes the graphs and KPIs. 

 

The top left toggle, which I believe is a Navigation & Actions extension, is defined by these parameters below, where vMeasure is defined as: num(Sum([Contract Sales]),'$#,##0;($#,##0)')

Nolan_1-1594311050260.png

 

We are looking to add another sheet that looks the same, just with one added table. However when we recreate the sheet to look the exact same except with the added table, the graphs break and the toggle does not work.

 

Does anyone know where to start in fixing this issue? I am relatively new to extensions and variables in general, so any help would be appreciated.

 

Thanks

 

0 Replies