topic Re: Qliksense set analysis expression in App Development

Qliksense set analysis expression

New-Qlik — Tue, 18 Sep 2018 19:37:22 GMT

Hello ,

I have a requirement in which I need to calculate\

expression1 = Sales* quantity LFY/ weight* Quantity LFY

Note : LFY is last fiscal year and I have a column name LYear column have fiscal year

for quantity LYD I did = Sum({$<Year={$(=Max(LYear)-1)}>}quantity)

but when I try to multiply it with

Avg(Sales * Sum({$<Year={$(=Max(LYear)-1)}>}quantity))

Avg(price * Sum({$<Year={$(=Max(LYear)-1)}>}quantity))

it gives me no output. Any idea where ist going wrong.

vamsee — Tue, 18 Sep 2018 19:55:45 GMT

Try

( Avg({<Year={"$(=Max(LYear)-1)"} >}Sales ) * Sum({<Year={"$(=Max(LYear)-1)"} >}quantity) )

( Avg({<Year={"$(=Max(LYear)-1)"} >} price )* Sum({<Year={"$(=Max(LYear)-1)"} >}quantity) )

-------------------------

You have to add set for Avg() also, Set Analysis is calculated Once Per Chart not at every row.

New-Qlik — Tue, 18 Sep 2018 20:18:50 GMT

Same expression I have to calculate as LYTD ie last year to date. can u help

Avg(Sales * LYTDquantity))

Avg(price * LFYquantity