topic Dimension over all document in QlikView

Dimension over all document

Mon, 31 Mar 2014 09:28:27 GMT

I have a dimension PERIOD which contains YYYYMM. I want to use it in a graph without being limited by the current selection. I.o.w. I'd like to see all available periods at all times in stead of the maybe only one selected. Must be a simple thing...but newbe....

Re: Dimension over all document

datanibbler — Mon, 31 Mar 2014 09:35:31 GMT

Hi Milo,

[first of all, just as a thought - the header of your post suggests sth. quite different, namely that you want to make your dimension universally available, which could be done by putting it into a variable (as an expression)]

There are several possibilities to make the dimension independent of selections (although thereby you kind of block an integral part of QlikView's abilities):

=> Tick the checkbox "read_only" on the "general" tab of the properties_dialog of your chart.

HTH

Best regards,

DataNibbler

Re: Dimension over all document

simondachstr — Mon, 31 Mar 2014 09:37:16 GMT

Use the set modifier sum({<PERIOD= >} measure) in each of your expressions.

Re: Dimension over all document

ashwanin — Mon, 31 Mar 2014 09:39:37 GMT

Please attach sample data of your desired output