topic Re: Set Analysis - Graph in QlikView

Set Analysis - Graph

joris_lansdaal — Thu, 08 Sep 2016 13:58:32 GMT

Hi all,

I've got a challenge that I'm not able to tackle. Below graph shows the volume progress over the month compared with last month and a lineair projection. The challenge is that the the 'Day' axis always shows 31 instead of the number of days in the currenth month.

When I select 'Sep' in the dimension Month the graph obviously will show 30 days. So I tried below set analysis with

=Sum({<CurMTDFlag={1},Month={"=Month(maxDate)"}, Local_Flag={1}>} $(VarFact)), but that doesn't do the trick.

Should I use the Day dimension or is my set analysis incomplete/wrong?

Thanks

Re: Set Analysis - Graph

Anonymous — Thu, 08 Sep 2016 14:10:07 GMT

you Should need to use Date->'DD'as dimension

Re: Set Analysis - Graph

sunny_talwar — Thu, 08 Sep 2016 14:13:14 GMT

Are you trying to get rid of the extra days which doesn't have a bar?

Re: Set Analysis - Graph

joris_lansdaal — Thu, 08 Sep 2016 14:18:45 GMT

September has 30 days and I'm trying to get rid of day 31

Re: Set Analysis - Graph

sunny_talwar — Thu, 08 Sep 2016 14:23:32 GMT

May be try using Day(Date) as your dimension and see what happens

Re: Set Analysis - Graph

NickHoff — Thu, 08 Sep 2016 14:24:38 GMT

Day(MonthEnd(YourDateField))

Re: Set Analysis - Graph

joris_lansdaal — Thu, 08 Sep 2016 14:31:43 GMT

This is the end result I'm looking for. (Don't mind the table and meter...)

Re: Set Analysis - Graph

sunny_talwar — Thu, 08 Sep 2016 14:56:36 GMT

Did you try using Day(Date) as your dimension?

Re: Set Analysis - Graph

joris_lansdaal — Thu, 08 Sep 2016 15:31:09 GMT

Yes, Day(Date) is the used dimension

Re: Set Analysis - Graph

sunny_talwar — Thu, 08 Sep 2016 15:32:44 GMT

Can you check your calendar to check if September somehow have 31 days in the script

Re: Set Analysis - Graph

joris_lansdaal — Thu, 08 Sep 2016 15:40:08 GMT

That's all ok. I doubled checked already.

Re: Set Analysis - Graph

sunny_talwar — Thu, 08 Sep 2016 15:55:56 GMT

Would it be possible for you to share a sample to see the issue?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Set Analysis - Graph

joris_lansdaal — Thu, 08 Sep 2016 18:29:03 GMT

Here's the example. Thanks for the link!