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: 
JMAROUF
Creator II
Creator II

num() function within set analysis

Hi everyone,

I have a field wich is text, can'i get his num value within set analysis without reloading the app? i want exactly something like this: 

=num(count({1 <NUM(CRMB)={'*'}-{40, 41}}>}MvtB),'# ##0')

It's possible?

Thank you in advance.

Labels (1)
10 Replies
Kushal_Chawda

@JMAROUF  or try below

=count({1<CRMB = {"=num#(CRMB)<>40 and num#(CRMB)<>41"}>}MvtB)