Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
124psu
Creator II
Creator II

KPI integrated with variable for dynamic kpi upon filter pane selection

Exactly how the title is - I would like to grab the count of open "Accounts" when a user selects a value from the filter pane (Region). 

My syntax -

Count({<[Open/Close] = {"Open"}, Region = {'$vRegion'}>} [Open/Close])

In my variable set up, I have made the definition to be = 'Region'. I think my formula should be working. I think the problem occurs with my variable set up. Currently my variable set up is vRegion = Region (the column/field). Should this be something else? 

 

Labels (2)
1 Solution

Accepted Solutions
vmoreno2605
Creator
Creator

The right sintaxis for a variable in set analysis is in this case
Region={"$(vRegion)"}

And about your vRegion=Region i diddn't understand, can u take a picture of your variable function?

View solution in original post

2 Replies
vmoreno2605
Creator
Creator

The right sintaxis for a variable in set analysis is in this case
Region={"$(vRegion)"}

And about your vRegion=Region i diddn't understand, can u take a picture of your variable function?

124psu
Creator II
Creator II
Author

Ok got it the parentheses were missing. That fixed it. Thanks!