Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
Try below expression:
sum({<[Metai ketvirtis] = {'$(vMinQ)'}>} [Likutis.Suma])
HTH
Sushil
Thank you, Ashfaq Mohammed!
Adding = sign to the variable definition did help. Expresion was ok
Hi,
If it answer, Can you close thread by marking it as appropriate answer.
Regards
ASHFAQ