topic Re: Using dimensions as a filter in QlikView

Using dimensions as a filter

Mon, 13 May 2013 09:14:52 GMT

How can i use the pivot dimensions as a filter for quick acces to dimensions.

sushil353 — Mon, 13 May 2013 09:21:00 GMT

Please explain your issue a bit more.. it is not clear what is your issue.. if possible put some example also.

narender123 — Mon, 13 May 2013 09:26:06 GMT

Hi,

For filter ,You could use list box.Take the dimention in list box "field".

Thanks.

Mon, 13 May 2013 09:36:19 GMT

I have 4 level dimensions on the pivot table.

Level1, Level2, Level3, Level4.

I want to use these dimensions like a list box filter..

and I want to expand the desired level dimension on these filters.

Many thanks..

Mon, 13 May 2013 09:46:07 GMT

I don't want dimensions values on the list box.

I have 4 level dimensions on the pivot table.

Level1, Level2, Level3, Level4.

I want to use these dimensions headers like a list box filter..

and I want to expand the desired level dimension on these filters.

Thanks.

sushil353 — Mon, 13 May 2013 09:50:23 GMT

hi,

Try this:

goto presentation tab.. there just select the dimension and check the Dropdown select checkbox.

HTH

Sushil

Mon, 13 May 2013 10:03:42 GMT

Thank you very much, but unfortunately not helping.

There are so many records in each dimension and i don' t want to see these records on the dropdown menu.

I want to see only desired level dimension to expand.

Thanks..

sushil353 — Mon, 13 May 2013 10:16:44 GMT

Please explain your requirement with some example or screen shots..

i am not getting the meaning of "desired level dimension".

~sushil