Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
JMAROUF
New Contributor III

count expression with conditions

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.

Labels (3)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: count expression with conditions

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

View solution in original post

4 Replies
trdandamudi
Honored Contributor II

Re: count expression with conditions

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.

 

Highlighted
Partner
Partner

Re: count expression with conditions

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

View solution in original post

sasiparupudi1
Honored Contributor III

Re: count expression with conditions

Please post a sample app..

 

JMAROUF
New Contributor III

Re: count expression with conditions

hello @trdandamudi

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