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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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