topic Re: Last 4 week from latest week - Latest week diffrence through Set Analysis in QlikView

Last 4 week from latest week - Latest week diffrence through Set Analysis

sridhar_sigired — Wed, 19 Oct 2016 12:24:55 GMT

Hi,

I have confusion with set analysis whether i can use <= or >= with in set analysis.

I am trying to create last field in attached table which is "Difference with 5th Week". I have created pivot table as available in attachment except last field "Difference with 5th Week", i want to create it separately with same dimension and want to keep right side of pivot table.

Here i want to create a expression Avg(last 4 weeks from previous week - amount) -Sum(latest week amount)..

Can you please help me how to take 4 weeks in set analysis (i will create variable), just need help on how to write expression.

Re: Last 4 week from latest week - Latest week diffrence through Set Analysis

shraddha_g — Wed, 19 Oct 2016 12:27:18 GMT

You can use <= and >= in set analysis

Re: Last 4 week from latest week - Latest week diffrence through Set Analysis

sunny_talwar — Wed, 19 Oct 2016 12:28:41 GMT

There is one example of <= here:

Dates in Set Analysis

Re: Last 4 week from latest week - Latest week diffrence through Set Analysis

sridhar_sigired — Thu, 20 Oct 2016 03:21:57 GMT

Hi Sunny,

When we use variable in set expression, we do use $, right?

I am creating expression for each of previous weekend and creating pivot table like below

Let vLatestWeek = Date(WeekEnd(Today()),'MM/DD/YYYY')

Let vPreviousWeek = Date(WeekEnd(Today(),-1),'MM/DD/YYYY') so on...

Expression is like below

sum({<Week={$('vLatestWeek')}>}Sales) or

sum({<Week={$(vLatestWeek)}>}Sales) or

It is not working, however i tested with below and working

sum({<Week={'10/23/2016')}>}Sales)

Do we need to remember any specific point while we use variable in set expression? Checked in help, and syntax looks correct.

Re: Last 4 week from latest week - Latest week diffrence through Set Analysis

shraddha_g — Thu, 20 Oct 2016 03:45:29 GMT

Try this:

sum({<Week={"$(=vLatestWeek)"}>}Sales)

Re: Last 4 week from latest week - Latest week diffrence through Set Analysis

sridhar_sigired — Thu, 20 Oct 2016 04:10:10 GMT

Thanks Shraddha... Tried but not getting result.

Re: Last 4 week from latest week - Latest week diffrence through Set Analysis

shraddha_g — Thu, 20 Oct 2016 04:12:35 GMT

Try

sum({<Week={"$(vLatestWeek)"}>}Sales)

Re: Last 4 week from latest week - Latest week diffrence through Set Analysis

sridhar_sigired — Thu, 20 Oct 2016 04:26:30 GMT

Nice thanks Shraddha for your time...