topic set analysis for previous month - non-drillable? in QlikView

set analysis for previous month - non-drillable?

Mon, 21 Feb 2011 13:38:03 GMT

Hi guys,

I've implemented a simple previous month expression and thought it was working perfectly....That is until I made another selection.

1st expression: Sum(Case)

2nd expression Sum({$1<Master_Calendar_MonthYear = {"$(=date(AddMonths(Master_Calendar_MonthYear,-1), 'MMM-YYYY'))"}>}Case)

However, now when I select for example a geographical location, the 2nd expression remains static and therefore brings back all of last months cases and not just the selected city.
Any thoughts?

thanks,

set analysis for previous month - non-drillable?

Mon, 21 Feb 2011 14:50:51 GMT

Hello,

simply remove the 1 in your set expression.

{$< ....>} or just {<...>}

The 1 means to query on the full data set, ignoring all your selections.

$ (or nothing) keeps existing selections, just overrides the part which is defined in the set.

hth,
Thilo

set analysis for previous month - non-drillable?

Mon, 21 Feb 2011 15:13:39 GMT

Hi,

thanks for your reply. I did try this but it returns zero unfortunately!

set analysis for previous month - non-drillable?

Tue, 22 Feb 2011 10:16:50 GMT

Basically it doesn't recognise the expression at all without the "1" in there and brings back a zero result. I'm assuming there must be a way in which the previous month expression can be made drillable and not just looking at the full set?