topic Re: Set analysis and 'QlikView Components' in QlikView

Set analysis and 'QlikView Components'

Sat, 08 Feb 2014 09:05:55 GMT

Hello.

I've checked great 'QlikView Components' project. I can see, that it has a set expressions for previous month, previous year and previous quarter. But I can't find anything for:

- previous week

- rolling X days / weeks / months

Also, I can't understand, what is the vSetXXXModifier for? What do they modify and what for?

Re: Set analysis and 'QlikView Components'

Gysbert_Wassenaar — Sat, 08 Feb 2014 19:32:55 GMT

You're correct that there are no standard set analysis expressions for the previous week. But it's very easy to add:

Take the set modifier for previous month and replace

[_MonthSerial] = {$(=Max({1<_Qvc.DummyField=$(_Qvc.Calendar.v.SelectedFieldList_)>} [_MonthSerial]) - 1)}

with

[_WeekSerial] = {$(=Max({1<_Qvc.DummyField=$(_Qvc.Calendar.v.SelectedFieldList_)>} [_WeekSerial]) - 1)}

There is a rolling12 months set analysis expression. Again the rolling12 modifier can be easily adapted to any number of months. Just change the 11 to the number you need.

For days and weeks you can again take the [_MonthSerial]= {...} part and replace _MonthSerial with _DateSerial respectively _WeekSerial to adapt the expression for days or weeks.

The vSetXXXModifier is the part that overrules the user selections (i.e. modifies the set) to create the set that the calculation in the expression is applied to.

Re: Set analysis and 'QlikView Components'

Sun, 09 Feb 2014 15:45:48 GMT

Thanks a lot. But where did you take that source code? The code from latest QvcComponents look like:

// Previous Month To Date

Let $(_fieldPrefix)vSetPreviousMonthMTDModifier =

MapSubString('_qvctemp.Calendar.EscapeCharsMap',

'$(_vClearFieldList)

$(_f_MonthSerial) = {@(=$(_qvctemp.vMaxModifier) $(_f_MonthSerial)) - 1)},

$(_fDay) = {"<=@(=Day($(_qvctemp.vMaxModifier) $(_f_DateSerial))))"}'

);

Let $(_fieldPrefix)vSetPreviousMonthMTD =

MapSubString('_qvctemp.Calendar.EscapeCharsMap',

'{$<

@($(_fieldPrefix)vSetPreviousMonthMTDModifier)

>}'

);

Re: Set analysis and 'QlikView Components'

rwunderlich — Sun, 09 Feb 2014 16:00:34 GMT

There is some explanation of the SetXXXModifier in the QVC release notes in the section named "Changes for V6".

Doc for available variables is in the QvcDocumentation.qvw, Detail sheet, select Qvc.Calendar and look in the Variables section.

The generated variables and their values (what Gysbert was copying and modifying) can be seen in the Qv variables overview. (Settings, Variables Overview)