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: 
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

1 Solution

Accepted Solutions
sunny_talwar

Try this as your expression:

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

View solution in original post

15 Replies
Anonymous
Not applicable
Author

Far easier to use the text values for a dual(), and set vShowDev to U or whatever text value you need.

     count({<Bulk_Flag={'$(vShowDev)'}>}Bulk_Flag)

Not applicable
Author

the problem is that other value have space in string "N U"...  and in second value i want to pass 'U','N U'

how can i handle this?

Not applicable
Author

and as i told button is not behaving good when i use if(vShowDev=0,'U','N U')


with this, button is worked for one time only

sunny_talwar

Tried using the if?

=Count(If(Bulk_Flag = vShowDev, Bulk_Flag))

Best,

Sunny

Anonymous
Not applicable
Author

count({<Bulk_Flag={"=num(Bulk_Flag)=$(vShowDev)"}>} Bulk_Flag)

sunny_talwar

PFA the application.

Best,

Sunny

Not applicable
Author

Hi Michael ,urs idea is working ...

can u please explain me the logic

Not applicable
Author

Hi Gurjeet,

PFA application.

Hope u are looking the same.

Thanks,

Ashok.

Anonymous
Not applicable
Author

It is not allowed to use functions here:

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

It must always be field name:

<field={something}>}

Now, replace "something" with any expression you may need, in this case:

<field={"=num(Bulk_Flag)=$(vShowDev)"}>}"}>}