topic Re: Issue with Set Analysis in QlikView

Issue with Set Analysis

raajeshn — Fri, 27 Jul 2012 16:11:55 GMT

Hi Experts,

I am running into an issue with respect to set analysis.

This is the scenario - I have a Sales Report where I am showing Sales (of a Product) with respect to Dates (Dimension) - to be more specific 30 dates rolling from the selected date. One of the KPI is to show the Total Sales of the last 7 Days. Hence, my output will look like this (if 30-Jan-2012 is selected)

Date	Total Sales	Total Sales in Last 7 Days
01-Jan-2012
02-Jan-2012
....
....
30-Jan-2012

The total sales condition works well if it is just one date (as I am showing things at row level. If I write a set expression to include last 7 days, it again get distributed. Is there a way - I can evalute each of the expression inside the cell? Appreciate your help.

Thanks & Regards,

Raajesh N

Re: Issue with Set Analysis

Fri, 27 Jul 2012 19:02:51 GMT

The following will work but would give wrong answers to first 6 days

RangeSum(Above(Sales,0,6))

To arrive at the desired results irrespective of the selections you need to do it at script. If the values are from database (for eg. Oracle) you can use sum function with partition by clause.

Kiran.

Re: Issue with Set Analysis

CELAMBARASAN — Fri, 27 Jul 2012 20:14:02 GMT

Use your expression in dollar expansion like below

$(=Expression)

Re: Issue with Set Analysis

raajeshn — Sat, 28 Jul 2012 03:20:33 GMT

Hi Kiran,

Thanks for the response. I tried your idea earlier and did not find it usefull. Can you please share an example on how to do this?

Thanks & Regards,

Raajesh N

Re: Issue with Set Analysis

raajeshn — Sat, 28 Jul 2012 03:21:47 GMT

Hi Celambarasan,

Thanks for the response. However, I have already tried this and it does not work. Can you please attach an example of the working version.

Thanks & Regards,

Raajesh N