Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
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
Highlighted

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

Highlighted
Master II
Master II

Hi,

Try below expression:

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

HTH

Sushil

Highlighted
Contributor II
Contributor II

Thank you, Ashfaq Mohammed!

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

Highlighted

Hi,

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

Regards

ASHFAQ