topic Excluding dimension values in QlikView

Excluding dimension values

Thu, 14 Apr 2011 15:48:02 GMT

Hi.

I need to create a chart with some dimensions and measures.

For one dimensions I need to exclude some values to don't show the related measure values. For this dimension I haven't to create a list box with the dimension values. I think to edit the dimension inside the chart.

Any suggests to me, please? Thanks

Excluding dimension values

erichshiino — Thu, 14 Apr 2011 18:48:40 GMT

You may edit the dimension expression on a chart (creating a calculated dimension).

for example

if(Year>2000,Year).

Another option is to use set analysis in all your expressions in the chart to exclude dimensions that get null results.

Rgds,

Erich

Excluding dimension values

Fri, 15 Apr 2011 08:15:25 GMT

Ok, thanks, it is a good tip.