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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

need help with set analysis

i have a field using dual function,

and i have created a toggle button - (i checked its behavior it is working fine with number i.e.1,0 not with the string)

now the problem in set analysis when i use

{<num(field)={'variable'}>}

please find attached document

15 Replies
Not applicable
Author

help me out more ---

button = 0

show only U  value

button = 1

show both 0(N U) and 1(U) values

sunny_talwar

Right now it is not showing both when variable = 1, do you want it to show both??

Best,

Sunny

Not applicable
Author

yes

sunny_talwar

Try this as your expression:

=Count({<Bulk_Flag={"=num(Bulk_Flag)=$(vShowDev)"} + {"=num(Bulk_Flag)=0"}>} Bulk_Flag)

Not applicable
Author

thanks alot

sunny_talwar

Not a problem.

Sunny