Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy
Master III
Master III

count using set analysis based on selection

Hi Team,

i have the listbox for "Status". that contain "i1","i2","i3", like that.

i need count for if the type is "finished" or "Pending". But the status should be i1,i2, i3 and i4.

=Count(distinct

{

<

  type={'finished'},

  Status={'i1','i2','i3','i4',' '}

>

+

<

  type={'Pending'},

  Status={'i1','i2','i3','i4',' '}

>

}  Product)

Now, i need the count based on the Status. If i select "i1",  I need the count for Status "i1".

could you please give me the expression.

Thanks & regards,

Sethu

6 Replies
Not applicable

Hi,

Count(distinct{< type={'finished','Pending'}>} Product)

Regards,

Joshmi

settu_periasamy
Master III
Master III
Author

Hi Joshmi,

i need to consider the status also.

when i select the status, that should only show.

regards,

sethu

ychaitanya
Creator III
Creator III

i hope you can use combination of GetFieldSelections() to identify the slected value

if(GetFieldSeclections(type='Pending'),sum({<Status={'i1','i2','i3','i4',' '}> Sales)

,sum({<status={'i1','i2','i3','i4'}>Sales)

Regards

Chaitanya Y

Not applicable

Hi,

Please try this,

Count(distinct{< type={'finished','Pending'}>} if(Match(Status,'i1','i2','i3','i4'), Product))

Regards,

Joshmi

settu_periasamy
Master III
Master III
Author

will check

ychaitanya
Creator III
Creator III

Hi

Have you used my recommendation.

Thanks

Chaitanya