topic Re: Conditional show when dimension is changed in QlikView

Conditional show when dimension is changed

Wed, 17 Sep 2014 08:36:57 GMT

I have a dimension group on my x-axis called 'Time'. It consists of the two fields Week and Month.

I have a particular expression i only want to be visible on the chart when the user is viewing the chart by Week and not by Month.

What would the expression be for a conditional show to achieve this?

tresB — Wed, 17 Sep 2014 08:43:33 GMT

=If(GetCurrentField(YourGroup)='Week' , ....,..)

Anonymous — Wed, 17 Sep 2014 08:47:55 GMT

Hi Alex

Island you fields names as %Dims and on the expression

select Enable and Conditional and use this line

=Alt( Match ( GetFieldSelections(%Dims, '|'), 'Time' ), 0 )

Wed, 17 Sep 2014 08:51:51 GMT

Thanks Tresesco

This was the final expression I used

=IF(GetCurrentField(Time)='CalendarWeekStart',1,0)

Anonymous — Wed, 17 Sep 2014 08:52:04 GMT

Hi Alex,

I jus tested tresesco`s solution it works good and easy to implement