topic Re: count expression with conditions in QlikView

count expression with conditions

JMAROUF — Sat, 16 Nov 2024 03:08:50 GMT

hello every one,

i have an issu with this expression :

=num(count({1 < [field1]={'val1','val2','val3','val4','val5','val6','val7','val8,'Val9','val10'},
[field2]={'>0'},[field3]={'>0'} >} distinct target),'# ##0')

it gives a wrong result.

Re: count expression with conditions

trdandamudi — Fri, 28 Jun 2019 18:28:38 GMT

Please give a try with the below expression:

=count({1<field1={'val1','val2','val3','val4','val5','val6','val7','val8','Val9','val10'},field2={'>0'},field3={'>0'} >} distinct target)

Hope this helps.

Re: count expression with conditions

Prashant_Naik — Sat, 29 Jun 2019 18:10:39 GMT

Hi,

This might help, I have bold the changes

num(count({1 < [field1]={'val1','val2','val3','val4','val5','val6','val7','val8,'Val9','val10'},
[field2]={">0"},[field3]={">0"} >} distinct target),'# ##0')

Regards,

Prashant

Re: count expression with conditions

sasiparupudi1 — Sat, 29 Jun 2019 18:43:38 GMT

Please post a sample app..

Re: count expression with conditions

JMAROUF — Mon, 01 Jul 2019 08:34:11 GMT

hello @trdandamudi,

thank you for the try but it doesn't solve the problem yet, the result is 0 !!