Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
settu_periasamy

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
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
Author

will check

ychaitanya
Creator III
Creator III

Hi

Have you used my recommendation.

Thanks

Chaitanya