topic display expression as a dimension in a pivot in QlikView

display expression as a dimension in a pivot

lmonincx — Thu, 27 Aug 2009 16:58:46 GMT

Hi,

I am trying to establish that i can show a sum(Budget) as one value acting as a dimension in a pivot is this possible? I don't want it as a measure as i only want it listed once and not displayed for every month on top .

Month

Jan 09 Feb 09

Product sum(Budget)

A 200 160 40

Is this possible?

Thanks for any help!

Regards, Linda

display expression as a dimension in a pivot

Thu, 27 Aug 2009 17:14:12 GMT

Hi Linda,

I dont think you need to have it as a dimension to display data in this fashion. All you need to do is tweak the pivot a little as done in attached example. Let me know if this solves your problem.

Thanks

Amit

display expression as a dimension in a pivot

lmonincx — Thu, 27 Aug 2009 17:26:05 GMT

Hi Amit,

Thanks that works , is it also possible to change the name of the label, now the expression is shown as label?

Regards, Linda

display expression as a dimension in a pivot

lmonincx — Thu, 27 Aug 2009 17:29:38 GMT

oops no this still doesn't work, its still summing the expression (actuals) and i would like to sum on a different measure ' budget' I would like total on a different measure than used in the expression.

display expression as a dimension in a pivot

Thu, 27 Aug 2009 17:57:19 GMT

Well in that case it could be solved by adding the Budget as a dimension. Please see the attached file how it could be implemented.

Thanks

Amit

display expression as a dimension in a pivot

lmonincx — Thu, 27 Aug 2009 18:36:06 GMT

Thanks that will do!

Linda

Re: display expression as a dimension in a pivot

rajni_batra — Thu, 12 Apr 2012 05:48:12 GMT

in the table i have added so may expressions but want them as dimension so that user could select any of them from their hoice is their any way to do that. i did mention only a few expressions but a lot to implement..

thnks n regards........