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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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!