topic set analysis question in QlikView

set analysis question

Wed, 01 Jul 2015 17:48:11 GMT

Hi,

I have the following expression.

count({1<SMI_Position01.BusinessDate = {'$(vPreviousBusinessDate)'} >}BusinessDates_Final.PreviousBusDate)

vPreviousBusinessDate is a date which is storing a date field. I can see that the vPreviousBusinessDate has the correct value in another windows, but I am not sure if the {'$(vPreviousBusinessDate)'} is the correct expression, I have tried different variations but I don't get a value, stays 0. Also I am looking for historic data, so I assume it's correct to have 1 and not $.

Thank you,

Panos.

Re: set analysis question

Qrishna — Wed, 01 Jul 2015 17:55:19 GMT

Hi,

if the variable vPreviousBusinessDate holds another expression to be evaluated then you have to use {'$(=vPreviousBusinessDate)'} in the set analysis.

if vPreviousBusinessDate is just a value then your expression seems to be legit.

Coming to the 'Value is 0' check if there are any other expressions or triggers on the sheet which changes the variable value.

Cheers

krishna

Re: set analysis question

maxgro — Wed, 01 Jul 2015 18:03:41 GMT

maybe you need to format the date

count({1<SMI_Position01.BusinessDate = {'$(=date($(vPreviousBusinessDate)))'} >}BusinessDates_Final.PreviousBusDate)

add your expression in a chart (it's ok also withoud dims), remove the label and look at the date as in image; it should be as SMI_Position01.BusinessDate

Re: set analysis question

Thu, 02 Jul 2015 10:46:41 GMT

Hi,

That works thank you! however I am now facing another issue. As i am using count({1< that means i am selecting the whole book and i think that it ignores current selections made on the book. Is there a way to include the current selection a user makes within the set analysis calculation somehow. The data I need is always for previous business date if makes any simpler.

Thank you!

Panos.