topic Re: Alternate states in QlikView

Alternate states

kevbrown — Wed, 11 May 2016 15:02:55 GMT

I'm looking at comparison data, this week on last, or this year on last. My customer would like a straight table but would also like the ability to choose his own date range. Ideally Alternate States would do this for me, however can alternate states be produced in one straight table as they would also like a % difference column. In a nut shell, i would like to be able to have a straight table, comparing year against year for arguments sake but I can change the dates to maybe a week or data or a single day. I also need a % difference column for the 2 dates.

Make any sense?

Kev

Re: Alternate states

sunny_talwar — Thu, 12 May 2016 11:00:16 GMT

All of what you mention is possible. You can have multiple alternate states in a single straight table, but without seeing the data, it would be difficult to suggest anything. I mean I can create a sample for you, but it would be all my guesswork which may or may not fit your requirement perfectly. So in order to avoid any rework, I am going to ask you to provide some raw data (may be dummy) which is similar to your original data and provide information about what will be the dimension on which we would be seeing all this.

Best,

Sunny

Re: Alternate states

kevbrown — Thu, 12 May 2016 12:57:53 GMT

in a qvw?

Re: Alternate states

sunny_talwar — Thu, 12 May 2016 12:59:22 GMT

qvw would be ideal

Re: Alternate states

kevbrown — Thu, 12 May 2016 13:08:57 GMT

I would like to see a comparison of dates, so that could be weeks or months or years, with a %Diff to calculate the difference between those weeks or months or years

Kev

Re: Alternate states

sunny_talwar — Thu, 12 May 2016 15:06:53 GMT

Can you try this and see if this is what you want?

Re: Alternate states

kevbrown — Thu, 19 May 2016 07:22:06 GMT

That's superb, thanks Sunny.