topic Eliminate rows based on status history in QlikView

Eliminate rows based on status history

Thu, 29 Oct 2015 15:33:17 GMT

Hello All,

I have a requirement to display straight chart with records status as Inactive .

I was able to achieve this using set analysis expression =Sum({<Status={'Inactive'}>} FEE)

Now I have another requirement whenever Quarter is selected if anytime status is Active then that record should disappear from above chart

When Q3 is selected INC Cname data should not be displayed since it was active in Q3

When Q4 is selected CLI Cname data should not be displayed since it was active in Q4

Other records will remain same

Attached is the data sheet and Qv file.

Please help

Gysbert_Wassenaar — Fri, 30 Oct 2015 15:00:59 GMT

Perhaps like this =Sum({<Quarter=, Status={'Inactive'}, CName=E({<Status={'Active'}>}CName)>} FEE)

Mon, 02 Nov 2015 18:47:13 GMT

Hi Gysbert,

If the above condition is applied by default I would not see any view....

My requirement is by default it should display all the inactive records.

When month or quarter is selected it should check if the cname is active in that particular month or quarter and eliminate those records.

When Jul is selected INV Cname data should not be displayed since it was active in Jul

When Aug is selected INV Cname data should not be displayed since it was active in Aug

When Sep is selected INV Cname data should not be displayed since it was active in Sep

When Oct is selected CLI Cname data should not be displayed since it was active in Oct

When Q3 is selected INC Cname data should not be displayed since it was active in Q3

When Q4 is selected CLI Cname data should not be displayed since it was active in Q4

This condition should work even when multiple months and multiple quarters are selected.

Please help

sunny_talwar — Mon, 02 Nov 2015 19:55:58 GMT

See if this expression works for you:

=If(GetSelectedCount(Quarter) = 0 and GetSelectedCount(Month) = 0,

Sum({<Status={'Inactive'}>} FEE),

Sum({<Quarter=, Status={'Inactive'}, CName=E({<Status={'Active'}>}CName)>} FEE))