topic Set analysis to display static graph in QlikView

Set analysis to display static graph

Thu, 16 Oct 2014 19:29:55 GMT

Can someone help me with this?

I need to be able to see from current week, 2 weeks of actual sales and historical forecast and 4 weeks of future forecast. In my example,

Current week in the application is 10/6/2014.

I need to see sales and historical forecast for: 9/29/2014, 9/22/2014

I need to see future forecast for: 10/6/2014, 10/13/2014, 10/20/2014, 10/27/2014

How can I make this happen? Attached is QVW file and data.

Re: Set analysis to display static graph

wms_manis — Thu, 16 Oct 2014 20:18:32 GMT

You needed the set expression on all the sum values.

sum({$< calendar_week = {">=$(=weekStart(snapshot_week,-2))<=$(=weekStart(snapshot_week,4))"}>} actual_sales)

sum({$< calendar_week = {">=$(=weekStart(snapshot_week,-2))<=$(=weekStart(snapshot_week,4))"}>}forecast_2)

I modified your file and attached it.

Hope it helps.

Wade

Re: Set analysis to display static graph

Thu, 16 Oct 2014 21:08:11 GMT

Wade, this is wonderful.

One question though. This works perfectly in my sample application. When I do it in my actual application, it gives me more than than 2 weeks for sales ( 7 weeks to be exact). Do you know why?

This is the script that I'm using:

sum({$< calendar_week = {">=$(=weekStart(snapshot_week,-2))<=$(=weekStart(snapshot_week,4))"}>} sales)

Does it matter if my dates are in weeknumber/year format or a monday date format?

Re: Re: Set analysis to display static graph

wms_manis — Thu, 16 Oct 2014 22:00:02 GMT

The date comparison is using the date value format.

One trick you can use to see how the expression is evaluated is to change the chart type to a Straight table and then remove the label. Now when you hover over the label, you can see how the set expression is being evaluated.

You may need to use Max(snapshot_week) if that has multiple values. Using max will not force you to set that field to only one selected.

Re: Set analysis to display static graph

jagan — Fri, 17 Oct 2014 04:01:56 GMT

Hi,

Try like this

Give this in Text object and check whether calendar_week and the below expression value are in same format, if both are in different format then your expression won't work.

weekStart(snapshot_week,4)

For set analysis date format should be same otherwise it gives invalid results.

If you have multiple snapshot_week then use

sum({$< calendar_week = {">=$(=weekStart(Max(snapshot_week),-2))<=$(=weekStart(Max(snapshot_week),4))"}>} sales)

Regards,

Jagan.