topic Re: getting data for max(columnname)in set analysis in QlikView

getting data for max(columnname)in set analysis

deepakqlikview_123 — Sun, 05 Jul 2015 17:04:33 GMT

hi All,

I have column as As of Date.I need to show data for max(As of Date) and for

max(As of Date)-182 for 2 different expressions.

but in set analysis i am unable to get data for these two diffent dates what in two different expressions.

Can you please suggest what would be syntax for this in set analysis.

thanks

sunny_talwar — Sun, 05 Jul 2015 17:08:57 GMT

What is the format of As of Date field?

For max As of Date: {<[As of Date] = {"$(=Date(Max([As of Date]), 'YourDateFormt')"}>}

For 6 months ago As of Date: {<[As of Date] = {"$(=Date(AddMonths(Max([As of Date]), -6), 'YourDateFormt')"}>}

HTH

Best,

Sunny

deepakqlikview_123 — Sun, 05 Jul 2015 17:49:33 GMT

Hi Sunny,

Can you please suggest how tao get date 182 days before from max(As of Date)

Thanks

sunny_talwar — Sun, 05 Jul 2015 17:52:59 GMT

Updated:

If you want to go exactly 182 back, you can use this:

Date(Max([As of Date]) - 182)

If going 6 months back will suffice you can use this:

Date(AddMonths(Max([As of Date]), -6))

deepakqlikview_123 — Tue, 07 Jul 2015 14:02:31 GMT

Hi,

PFA.

still i am not able to get data for max(DATE)

max(DATE)-182

and for max(DATE)-365

I have used 3 expressions for this.

Thanks

sunny_talwar — Tue, 07 Jul 2015 14:14:55 GMT

This is what you want?

Attaching the qvw for your reference.

Set analysis you need is this: DATE={"$(=date(MAX(DATE)-182,'M/D/YYYY'))"}

HTH

Best,

Sunny