topic Set Analysis in Dimension - Date & Previous Date in QlikView

Set Analysis in Dimension - Date & Previous Date

Anonymous — Wed, 11 Jan 2012 18:24:51 GMT

Hello

For each Date selected (DateID), I have a selection of Stocks (StockID) which I use as a dimension for a chart.
I would like to have not only the StockID for the selected date, but also the ones for the previous DateID.

I think I should use set analysis, but not sure how to do this in a Dimension...

Many thanks and regards

Set Analysis in Dimension - Date & Previous Date

Thu, 12 Jan 2012 10:16:00 GMT

Hi Zadig,

It may help you.

The general syntax for showing privious month and year with selcted month and year is

ex:- sum({$<YearID+={$(=MAX(Year)-1)}>}Sales) ->It will give you the sum of sales for selected year and its previous year ; You can use it for month instead of year

In your case:

count({$<DateID+={$(=MAX(DateID)-1)}>}StockID)