Re: Hide dimension by condition - Qlik Community

Report Inappropriate Content · ‎2014-01-21

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.

Report Inappropriate Content · ‎2014-01-21

Hi,

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

HTH

-Shruti

vikasmahajan · ‎2014-01-21

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

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

tresesco · ‎2014-01-21

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

Report Inappropriate Content · ‎2014-01-21

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.

or

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

Report Inappropriate Content · ‎2014-01-28

@

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!