topic Re: Calculated Dimension in table in QlikView

Calculated Dimension in table

rcorcoran — Thu, 28 Aug 2014 10:37:56 GMT

I am trying to put a calculated dimension in a table to get a metric to show. I have in the example below done it for three metrics (table 1) but the metric in Table 2 is a percentage calculation and I can't get this to work in the dimension of table 1 so it will show here aswell but have had to put it in a separate table with a calculated expression which i dont want

Can anyone help??

hope it makes sense

Re: Calculated Dimension in table

gmoraleswit — Thu, 28 Aug 2014 14:13:06 GMT

I changed it only for Jan, but you can replicate the solution for your other expressions:

Please see attached file.

Re: Calculated Dimension in table

rcorcoran — Mon, 01 Sep 2014 08:05:51 GMT

Thanks So much Gabriela you dont know how much this helps me.