Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

datadigger
New Contributor II

Set analysis with variable not working

Hi

In the document attached i'm trying to calculate warehouse turnover. I have multiple reminders in table [Likuciai] - one for each quarter.

Also i have stock movement in table [atsargos] (not used yet, just mentioned for the big picture).

User can select multiple quarters, qlikview should caculate remainder at the start of selected interval (not include other selected quarters).

I definied variable vMinQ as min([Metai ketvirtis]). [Metai ketvirtis] stands for the combination of Year + quarter.

Then i wrote set analysis expresion for remainder calculation: Sum( {$<[Metai ketvirtis]={$(=vMinQ)}>} [Likutis.Suma]).

Result = empty set.

Could anyone help me with that?

Thank you.

4 Replies

Re: Set analysis with variable not working

Hi,

Little = sign does that

http://community.qlik.com/blogs/qlikviewdesignblog/2014/11/24/the-equal-sign

Have a look at attached application

Regards

ASHFAQ

sushil353
Honored Contributor II

Re: Set analysis with variable not working

Hi,

Try below expression:

sum({<[Metai ketvirtis] = {'$(vMinQ)'}>} [Likutis.Suma])

HTH

Sushil

datadigger
New Contributor II

Re: Set analysis with variable not working

Thank you, Ashfaq Mohammed!

Adding = sign to the variable definition did help. Expresion was ok

Re: Set analysis with variable not working

Hi,

If it answer, Can you close thread by marking it as appropriate answer.

Regards

ASHFAQ

Community Browser