Set Analysis

Tue, 07 May 2013 16:26:33 GMT

I am using the following set analysis formula to return the total of the full set of data:

sum({1} Amount)

How can I modify my formula to return the current selection of the date selected but if any other selections are made I want it to return the full set for any other selection made. I have listed an example table below.

Example:

Data is as follows:

5/1/2013 Active $100

5/1/2013 Inactive $100

5/2/2013 Active $100

5/2/2013 Inactive $100

Total $400

If I select date of 5/1/2013 and select Active with the current formula sum({1} Amount) it returns

5/1/2013 Active $100

5/1/2013 Inactive $100

5/2/2013 Active $100

5/2/2013 Inactive $100

Total $400

I would like to be able to select the date of 5/1/2013 and select Active and return the following:

5/1/2013 Active $100

5/1/2013 Inactive $100

5/2/2013 Active $0

5/2/2013 Inactive $0

Total $200

This would hold the current selection of the date but show both the Active and Inactive total. Hopefully, this all makes sense.

Thanks

Brian

Re: Set Analysis

Gysbert_Wassenaar — Tue, 07 May 2013 16:29:11 GMT

Try sum({1<date=p(date)>} Amount). Change date withe the name of your date field.

Re: Set Analysis

Tue, 07 May 2013 18:13:06 GMT

That worked. Thanks for your help.

topic Re: Set Analysis in QlikView

Set Analysis

Re: Set Analysis

Re: Set Analysis