topic Re: Hide lines - line chart in QlikView

Hide lines - line chart

Thu, 25 Feb 2016 13:46:18 GMT

Can I hide lines (using the Conditional option) within a line chart based on the selections a user chooses? For example, re the below pic... if the user selects 'Access and Inclusion' and 'Sensory' for example, I'd like these two only to appear. If it is possible, can someone advise as to the conditional expression? Many thanks.

Re: Hide lines - line chart

Clever_Anjos — Thu, 25 Feb 2016 13:53:43 GMT

Maybe:

=index([WorkType],'Access and Inclusion') > 0 or index([WorkType],'Sensory') > 0

Re: Hide lines - line chart

Thu, 25 Feb 2016 14:13:47 GMT

That works but appears to be only partly what I'm after, but thanks so much for that

I'd like the line chart to initially show all of the Work Types until the user decides they want to see specific ones alongside each other. Using the expression you've given me will display the work types where only one is selected but doesn't work if more than one is selected, which is ideally what I'd like it to do.

Thanks.

Re: Hide lines - line chart

Clever_Anjos — Thu, 25 Feb 2016 14:16:50 GMT

Would you mind sharing a sample of your app?

Preparing examples for Upload - Reduction and Data Scrambling

Re: Hide lines - line chart

Clever_Anjos — Thu, 25 Feb 2016 14:18:16 GMT

Maybe

=index(concat([WorkType]),'Access and Inclusion') > 0 or index(concat([WorkType]),'Sensory') > 0

Re: Hide lines - line chart

Thu, 25 Feb 2016 14:27:10 GMT

Exactly what I'm after... thanks so much