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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use a variable into set analysis expression - Help!

Hello my friends,

I've the variable vFiltro

vFiltro = GetFieldSelections(Fato)

And I wrote this set analysis expression:

=Count({$<Fato={'$(vFiltro)'}>} DISTINCT %IDSalesForce)

When selected one value in my listbox 'Fato'..., display '0' when the expected is 688.

Why? Thanks

12 Replies
Not applicable
Author

Fato is a list box.

In this list box contains:

'Contac Center', 'Promo Digital', 'SMS'.

If I choose 'SMS' in this listbox, in my text box with the code 'GetFieldSelections(Fato)', the result is 'SMS'.

ashfaq_haseeb
Champion III
Champion III

you can even use this to exclude

Sum({<Produto=e(Produto)>}x)

did you check my attached file

Regards

ASHFAQ

Not applicable
Author

Now is correct!

Thanks!