topic Re: Dimension after Expression in QlikView

Dimension after Expression

Mon, 16 Apr 2012 12:09:54 GMT

hi all,

i'd like to ask, is it possible to add a dimension after an expression on pivot chart ?

thank you

Re: Dimension after Expression

v_iyyappan — Mon, 16 Apr 2012 12:18:19 GMT

Hi,

Dimension after expression possible in pivot table because its simply drag the ' dimension | expression ' in pivot table.

I attached a sample QV

Iyyappan

Dimension after Expression

rajni_batra — Mon, 16 Apr 2012 12:22:49 GMT

u used straight table in the example i dont think the same would b possible in pivot..

Dimension after Expression

Tue, 17 Apr 2012 09:04:11 GMT

is that straight table ? sorry i can't open the file you attached, i have personal edition here.. but thank you lyyappan

can you attach new file with pivot chart that shows a dimension after expression?

Dimension after Expression

Tue, 17 Apr 2012 09:16:03 GMT

Its not possible to have a dimension after an expression in a pivot table. This would break its ability to expand and collapse the pivot.

If you simply wish to display another field then you can do this using an expressions and the only() function which will display the value in the given field as long as only one distinct value is possible.