topic Re: Hide dimension by condition in QlikView

Hide dimension by condition

Tue, 21 Jan 2014 12:11:19 GMT

Hello,

I have two dimensions in the chart, but i need hide one when the sheet is selected.

Ex: the chart have the dimensions DATE and COUNTRIES.

1: when the sheet is selected the char show the sum of expressions by date(without the countries - BR, UK, USA,...), ie the dimension COUNTRIES is hidden.

Re: Hide dimension by condition

Tue, 21 Jan 2014 12:16:28 GMT

Hi,

If you using QV11, in that you can use conditional functionality in dimension tab.

HTH

-Shruti

Re: Hide dimension by condition

vikasmahajan — Tue, 21 Jan 2014 12:16:39 GMT

Find attached document hope will help you. You need to implement ad-hoc reporting

Vikas

Re: Hide dimension by condition

tresB — Tue, 21 Jan 2014 12:17:56 GMT

What do you exactly mean by 'when the sheet is selected' ?

Re: Hide dimension by condition

Tue, 21 Jan 2014 12:29:04 GMT

One way to achieve this to create 2 charts with one with Date Dimension and other with Countries dimension. And then you can show and hide the charts as per sheet activation.

You can can use a variable to dynamically shift dimensions.

Create a variable and set its value on sheet activation.

Like varTest = 1 for sheet SH01 and 2 for SH02

then in the chart you can use, IF statement in dimension.

If(varTest = 1, DATE, Countries)

Thanks,

Angad

Re: Hide dimension by condition

Tue, 28 Jan 2014 09:49:30 GMT

Dimensions

GetActiveSheetId() = 'Document\SH01' and getSelectedCount(dimensão) > 0

Expressions:

IF(GetActiveSheetId() = 'Document\SH01' and GetSelectedCount(dimensão) = 0, Sum(expressão), expressão)

Thanks!