topic Re: num() function within set analysis in QlikView

num() function within set analysis

JMAROUF — Fri, 15 Nov 2024 23:27:59 GMT

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.

Taoufiq_Zarra — Fri, 11 Dec 2020 10:57:45 GMT

@JMAROUF can you give an example from the count({1 <NUM(CRMB)={'*'}-{40, 41}}>}MvtB) text result ?

Kushal_Chawda — Fri, 11 Dec 2020 11:02:34 GMT

@JMAROUF may be you can try below

count({1 <CRMB-={'40', '41'}>}MvtB)

count({1 <CRMB=-{'40', '41'}>}MvtB)

JMAROUF — Fri, 11 Dec 2020 11:18:12 GMT

it doesn't work, with if() the formula is:

count(if(NUM(CRMB)<>(40 AND 41),MvtB)) the result is: 674 266

i'am looking for something like that with set analysis.

JMAROUF — Fri, 11 Dec 2020 11:43:16 GMT

the field CRMB is text, i want his num value within set analysis.

Kushal_Chawda — Fri, 11 Dec 2020 11:55:37 GMT

@JMAROUF why you want num when you are just giving any specific value in set?

JMAROUF — Fri, 11 Dec 2020 12:05:15 GMT

@Kushal_Chawda I want any numeric value else 40 and 41, but the field is text such 40, or 40,0 .....

Kushal_Chawda — Fri, 11 Dec 2020 12:07:14 GMT

@JMAROUF did you try what I suggested?

JMAROUF — Fri, 11 Dec 2020 12:21:12 GMT

Yes but it doesn't work, i have some values like this: '40,0000'

Kushal_Chawda — Fri, 11 Dec 2020 12:28:38 GMT

@JMAROUF the try below

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

Kushal_Chawda — Fri, 11 Dec 2020 12:30:55 GMT

@JMAROUF or try below

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