topic Re: count using set analysis based on selection in QlikView

count using set analysis based on selection

settu_periasamy — Mon, 13 Oct 2014 09:19:31 GMT

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

Re: count using set analysis based on selection

Mon, 13 Oct 2014 09:32:10 GMT

Hi,

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

Regards,

Joshmi

Re: count using set analysis based on selection

settu_periasamy — Mon, 13 Oct 2014 09:40:32 GMT

Hi Joshmi,

i need to consider the status also.

when i select the status, that should only show.

regards,

sethu

Re: count using set analysis based on selection

ychaitanya — Mon, 13 Oct 2014 10:00:13 GMT

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

Re: count using set analysis based on selection

Mon, 13 Oct 2014 10:13:30 GMT

Hi,

Please try this,

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

Regards,

Joshmi

Re: count using set analysis based on selection

settu_periasamy — Mon, 13 Oct 2014 10:15:30 GMT

will check

Re: count using set analysis based on selection

ychaitanya — Mon, 13 Oct 2014 10:28:27 GMT

Have you used my recommendation.

Thanks

Chaitanya