topic Re: Calculated dimensions in QlikView

Calculated dimensions

Fri, 20 Feb 2015 05:17:28 GMT

hi,

in my second table , i want acalculated dimension for all 4 quarters. IDEALLY, Q2 SHOULD BE below q1 and so on (not besid eit).

the calculation for each quarter (3 colums next to it) would be constant.

Appreciate help on this.

Re: Calculated dimensions

Anonymous — Fri, 20 Feb 2015 05:23:28 GMT

Can you explain bit more .... what do you mean by Q2 calculated dimension should be below Q1 .. can you post your expected output.

Re: Calculated dimensions

Anonymous — Fri, 20 Feb 2015 05:28:31 GMT

See below app .. if you are looking for the same result . Let me know if it is not correct in your case.

Re: Calculated dimensions

Fri, 20 Feb 2015 05:29:48 GMT

i belive i phrased my requirement incorrectly. i have 2 dimensions (pq and pm)...

in one table i can show 4 quarters (pq). however, in the smae table i want only 3 quarters (q1 should be excluded) and i want to add (m1,m2,m3) in the same table.

so, my table should have the following dimensions

q2,q3,q4,m1,m2,m3

attache is the updated file.

Re: Calculated dimensions

Fri, 20 Feb 2015 05:35:19 GMT

I believe we are neow on the same page. however, i am getting the same numbers for all 3 quarters. can you check this please....

Re: Calculated dimensions

Anonymous — Fri, 20 Feb 2015 05:45:04 GMT

you just want to exclude Q1 from your table correct .

See the below app.

Re: Calculated dimensions

Fri, 20 Feb 2015 05:57:26 GMT

yup..thanks a ton..can we add m1,m2,m3 in the same table?

Re: Calculated dimensions

Anonymous — Fri, 20 Feb 2015 06:23:13 GMT

As you have Q2,Q3,Q4 in your table and only M4 to M12 are falling under these qtrs .. so you can have M4 to M12

Let me know if you are looking for anything else.

If your problem resolved make appropriate ans helpful or correct so that it can help others .

Re: Calculated dimensions

Fri, 20 Feb 2015 06:27:33 GMT

i am not looking for a pivot option.

my requirement is to show those 7 fields one below other. thats my business requirement. i am not looking to get the corresponding months across the quarters. i just want a table wherein in each row i would be having

q3,q2,q1,,m2,m3

Re: Calculated dimensions

Anonymous — Fri, 20 Feb 2015 06:38:19 GMT

PFA

Re: Calculated dimensions

Fri, 20 Feb 2015 06:47:25 GMT

THATS PERFECT....i just done want m1 in the table. can you please just exclude m1 from the table.

thanks a ton

Re: Calculated dimensions

Anonymous — Fri, 20 Feb 2015 06:57:49 GMT

PFA

Re: Calculated dimensions

Anonymous — Fri, 20 Feb 2015 07:38:55 GMT

Is your Problem resolved ?

Re: Calculated dimensions

Fri, 20 Feb 2015 08:16:15 GMT

yup...thankx a ton for your assistance

Re: Calculated dimensions

Anonymous — Fri, 20 Feb 2015 09:05:04 GMT