# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for
Did you mean:
Creator

## Control date for a specific value in a set analysis

Hi,

I have a Pivot table that shows Sales for the last week and then sales last week compared to last year. I.e. Sales and Sales LY.

Sum({<[Store Type] = {'Concept', 'Estore', 'Outlet','Partner','SiS'}>} Fsgexkl_EUR*_YTD_TW_TY)

I'm using above set-analysis to keep the table set to a specific selection (concept, estore, outlet, partner, SiS).

The Fsgexkl_EUR is our sales and the _YTD_TW_TY calls for the sales in This Week and This Year (YTD gets the accumulated sales for that week).

So if we have week 33, the function will retrieve the sales for week 32.

Here's my problem:

I want the [Store Type] partner and SiS to retrieve data from two weeks prior. I.e. week 31 as per the example above.

So all selections, concept, estore etc. would retrieve data from week 32, as of now, but partner and SiS would retrieve data from week 31.

Is there a way to do this?

1 Solution

Accepted Solutions
Master III

Hi Robin,

maybe this

Sum({<[Store Type] = {'Concept', 'Estore', 'Outlet'}>} Fsgexkl_EUR*_YTD_TW_TY)+

Sum({<[Store Type] = {'Partner','SiS'}>} Fsgexkl_EUR*YourPriorWeek)

Regards,

Antonio

3 Replies
Master III

Hi Robin,

maybe this

Sum({<[Store Type] = {'Concept', 'Estore', 'Outlet'}>} Fsgexkl_EUR*_YTD_TW_TY)+

Sum({<[Store Type] = {'Partner','SiS'}>} Fsgexkl_EUR*YourPriorWeek)

Regards,

Antonio

Creator
Author

Thank you Antonio,

It works, but I had to setup a new Date dimension for it. But it got solved

Master III

Yes, You need it.

Regards,

Antonio

Community Browser