topic Set analysis with variable not working in QlikView

Set analysis with variable not working

Anonymous — Tue, 09 Dec 2014 08:43:05 GMT

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.

ashfaq_haseeb — Tue, 09 Dec 2014 08:49:25 GMT

Hi,

Little = sign does that

Have a look at attached application

Regards

ASHFAQ

sushil353 — Tue, 09 Dec 2014 08:50:52 GMT

Hi,

Try below expression:

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

HTH

Sushil

Anonymous — Tue, 09 Dec 2014 08:58:53 GMT

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

ashfaq_haseeb — Wed, 10 Dec 2014 04:54:21 GMT

Hi,

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

Regards

ASHFAQ