topic show hide chart on behalf of list box values in QlikView

show hide chart on behalf of list box values

qliklearnervir — Thu, 02 Apr 2015 14:12:11 GMT

Hi ,

In our requirement i have one list box called 'business' and values called 'generic' and 'safety' .

on behalf of generic i want to show charts and on behalf of safety another chart in same sheet.

kindly guide how to conditionally i can do this scenario.

Thanks.

Virendra

Thu, 02 Apr 2015 14:20:48 GMT

Hi,

You can write in expression sett analysis.

Chart1:

In dimension,

Fieldname

In Expression,

Sum({<business={'generic'} >} value_field)

Chart2:

In dimension,

Fieldname

In Expression,

Sum({<business={'safety'} >} value_field)

sunny_talwar — Thu, 02 Apr 2015 14:22:21 GMT

You can use this in your chart's conditional show expression:

GetFieldSelections(business) = 'generic' for 1st chart and

GetFieldSelections(business) = 'safety' for 2nd chart

HTH

Best,

Sunny

stigchel — Thu, 02 Apr 2015 14:23:27 GMT

You can conditionally show or hide objects, in the properties layout tab set conditional show and an expression.