4 quarterly meters in one sheet

[#1]

Dear all,

I'm pretty new to the qlikview community, but I couldn't work the following out (neither I could find it here on the community, hope there is a simple solution to it)

I have the target and actual data in my database, and I first present it in a table. I have the following colums:

Year, Week, Quarter, Target, Actual.

What I wanna do, is make 4 meters to see the results per Quarter (the data is only of 2010).

What I do is, I make the first meter and as a formula in the expression I use:

if(Quarter='Q1',sum(Actual)/sum(target)) , which gives me exactly what I want for quarter 1. But, if I copy and paste this meter and replace the Q1 by Q2 in the formula, my meter remains empty; not even the needle...

My Idea was to use this formula in four meters on a row, to keep track on the results per quarter...

Hope you understand what my idea is, and hope someone could give me a hand...

btw: As a dimension I use Quarter, but also other variables didn't work...

Thanks in advance,

Gijsbert

[boorgura]

hey, did you say that the year is 2010. if so, obviously you will have data for Q1 (current).

Correct me if i'm wrong.

Thanks,

Rocky

[vgutkovsky · Accepted solution]

I think Rocky makes a good point. I also think that what you are trying to do can be done much more elegantly with set analysis rather than an IF statement, and it will also save you memory.

Regards,

[#4]

Hope not, since Quarter is one of my fields of data, not an automated field... (in fact, I use the Dutch words so that should not be the case...)

Qlikview doesn't know it's 'kwartaal 1' at the moment... (so i translated my formula in English, probably wrong move..)

[#5]

Vlad, thanks for the tip.

Like I said, i'm new to the community and figuring out a lot of things... Will get started on the set analysis right away!

[#6]

THanks for the tips/right direction, got it working thanks to the Set analysis... This is what it became:

sum( {1<quarter= {'Q2'} >} Actual )/sum( {1<quarter= {'Q2'} >} target )

Thanks for helping a qlikview starter!