Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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