Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
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

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
Highlighted
Master II
Master II

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

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

Highlighted
Master III
Master III

Please post a sample app..

 

Highlighted
Contributor III
Contributor III

hello @trdandamudi

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