Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
Not applicable

Conditions on expression

Hi,

I have a client solution where they have a explaining text as an expression, set as Text as popup on a Dashboard/ Gauge Chart. Is it possible to add a condition to this expression so that it's just shown when RR_Business = Insurance?

I had solved this in version 10 and 11, but as the client is on version 9 I have to do it differently...

Expression:

=' ' & 'Helptext'

@Ungvall

Senior Business Discovery Manager at Advectas AB

1 Reply
Not applicable

Re: Conditions on expression

The easiest way would be changing the expression to null or helptext dynamically if Only(RR_Business) = 'Insurance'. Eventhough the popout comes it comes as null.

If you want to disable the textas popout dynamically, probably you need to trigger the macro when field selection is changed:

set chart = ActiveDocument.GetSheetObject("CH01")

set Prop = chart.GetProperties

Prop.ChartProperties.ShowValueInPopup(0) = true 'or false

chart.SetProperties Prop

Kiran.

Community Browser