Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

using variable to render straight table (expression)

I have a straight table with many columns that are pertaining to a sales person within a company. I have 5 buttons, related to that sales person, that I hope will render my table based on the user selecting a button.

 

if($(vTableFilter)= 1, sum({<SALES_PERSON= {"Michael Johnson"}>} SALES),
if($(vTableFilter)= 2, sum({<SALES_PERSON= {"Jordan Peele"}>} SALES),
if($(vTableFilter)= 3, sum({<SALES_PERSON= {"Kobe Bryant"}>} SALES),
if($(vTableFilter)= 4, sum({<SALES_PERSON= {"Lupe Fiasco"}>} SALES),
if($(vTableFilter)= 5, sum({<SALES_PERSON= {"Magic Johnson"}>} SALES)
)
)
)
)
)

My table doesn't seem to be rendering at all. I did a quick check by adding the SALES_PERSON column within the table and I can see that once I click a sales person (button) it still shows the other 4 individuals. Thoughts?

Labels (4)
3 Replies
Highlighted

Sugar is the definition of variable
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
MVP & Luminary
MVP & Luminary

Why so complicated and not just using SALES_PERSON as a listbox?

- Marcus

Highlighted
Partner
Partner

End users want something more interactive on a dashboard with buttons since there are only a few sales person. I was able to figure it out - for some reason once I deselected "null values" on the dimensions everything started to work. Thanks.