topic Re: set analysis not getting filtered???? in QlikView

set analysis not getting filtered????

Tue, 01 Sep 2015 13:58:57 GMT

Hello ,

In my database I have a table with following data

primary_key partners invoiced_status registration_status cancellation_status

1 abc invoiced registered cancelled

2 xyz not_invoiced not_registered not_cancelled

3 pqr not_invoiced failed cancelled

4 cde invoiced registered cancelled

5 abc

invoiced

registered

cancelled

6 xyz

invoiced

registered

not_cancelled

7 pqr

invoiced

failed

cancelled

I have created a straight table which contains data like given below:

partners registration_rate registerd_count unregistered_count

abc 95% 460 20

xyz 65% 340 30

pqr 58% 120 15

The formula that I have used for calculation are given below

registered_count //number of product which are registered and not cancelled

Count ({<[registration_status]={'REGISTD'},cancellation_status ={not_cancelled}>}[primary_key])

registration_rate // (num of product registered and not cancelled/ number product invoiced and not cancelled)*100

round((count({$<[invoiced_status]={'INVOICED'},[registration_status]={'REGISTD'},cancellation_status ={not_cancelled}} [primary_key])

/count({$<[invoiced_status]={'INVOICED'},cancellation_status ={0},[Invoice Date] = {'>=$(=v12MonthsBack)<=$(=v90DaysBack)'}>} [primary_key]))*100,0.01)

unregistered count

registered_count

Count ({<[registration_status]={'REGISTD'},cancellation_status ={cancelled}>}[primary_key])

Registration_status
Registered
failed
not_registered

.Even if user selects failed or not_registered from the list box.

the below formula shows only registered count.

the set analysis formula is not getting filtered ..I am not understanding why it is not getting filtered?..

registered_count

Count ({<[registration_status]={'REGISTD'},cancellation_status ={not_cancelled}>}[primary_key])

Re: set analysis not getting filtered????

sasiparupudi1 — Tue, 01 Sep 2015 14:26:42 GMT

shouldnt it be ? your table shows the string in lower case

Count ({<[registration_status]={'registered'},cancellation_status ={not_cancelled}>}[primary_key])

and it will always show the count for only registered values irrespective of the selection..

Is it what you wnat to achieve?

Re: set analysis not getting filtered????

ChiragPradhan — Tue, 01 Sep 2015 14:27:19 GMT

Because your set analysis expression is filtering on "REGISTD" registration status only.

Regards

Chirag

Re: set analysis not getting filtered????

Wed, 02 Sep 2015 13:20:26 GMT

No. I want the count to be calculated according to the filter. So when I select registration status as failed. The registered_count should be null.

Re: set analysis not getting filtered????

sasiparupudi1 — Wed, 02 Sep 2015 13:35:22 GMT

I say, remove the filter in your set analyis for registration status

Count ({<[registration_status]={'REGISTD'}, cancellation_status ={not_cancelled}>}[primary_key])

Re: set analysis not getting filtered????

Anonymous — Wed, 02 Sep 2015 13:40:21 GMT

hi divya,

unregistered count:

Count ({<[registration_status]={'not_registered'},cancellation_status ={'not_cancelled'}>}[primary_key])

Re: set analysis not getting filtered????

ellenblackwell — Fri, 16 Oct 2015 00:49:28 GMT

In your example, your cancellation_status parameter is not in single quotations.