topic Re: calculation based on user selection in QlikView

calculation based on user selection

Mon, 11 Aug 2014 13:56:51 GMT

Hi all,

I've got 3 time variables on my dashboard, year, month and quarter. behind the scenes I have 3 inflation tables, one for year, one for quarter and one for month. I have a calculation in a waterfall where the value you see depends on what time period the user has selected.

So when the user selects 2014 only the figure used for the calculation comes from the year table only.

If they select a particular year and then a quarter, e.g 2014 Q1 then the calculation comes from the quarter table.

If they select 2014 and Jan, then the figure used for the calculation comes from the month table.

I was trying to use something like if(Getcurrentfield)=year, perform calculation using value(s) from the year table,

if(Getcurrentfield)=quarter, perform calculation using value(s) from qtr table,

if(Getcurrentfield)=month, perform calculation using value(s) from year table.

Thanks

Adrian

Re: calculation based on user selection

Anonymous — Mon, 11 Aug 2014 18:48:13 GMT

Hi Adrian,

I would recommend placing this question in the "New to QlikView" message board. Qlik Sense is a brand new product, and it requires a new way of thinking for this business requirement since UI variables do not exist.

Try using logic in a calculate dimension that changes based on the DISTINCT COUNT of the different time fields. This approach works for both products.

Example:

=IF(COUNT(DISTINCT Month)=1, Year,

IF(COUNT(DISTINCT Quarter)=1, Quarter,

MonthYear))

Cheers,

Sean

Re: calculation based on user selection

Michael_Tarallo — Mon, 11 Aug 2014 19:01:06 GMT

Hi Adrian, I moved this over as per Sean's suggestion.

Mike

Qlik