topic Re: how to make a chart visible based on the value selected? in QlikView

how to make a chart visible based on the value selected?

Fri, 13 Dec 2013 05:49:18 GMT

Hi All,

My requirement is

Ex:

Say field name has a,b,c data

Now If I select a one chart should be displayed and if I select b one more chart should forb should be displayed and on c one more for c.

So my doc should have 3 charts.

How can I achieve this? I tried in layout conditional but its in appropriate. Can anyone help please?

Regards,

Prajna

Re: how to make a chart visible based on the value selected?

jagan — Fri, 13 Dec 2013 05:55:31 GMT

Hi,

Try like this in Chart Properties -> Layout -> Conditional

assuming that only one selected value in Field

For Chart a

=If(GetFieldSelections(FieldName) = 'a', 1, 0)

or just GetFieldSelections(FieldName) = 'a'

For Chart b

=If(GetFieldSelections(FieldName) = 'b', 1, 0)

or just GetFieldSelections(FieldName) = 'b'

For Chart c

=If(GetFieldSelections(FieldName) = 'c', 1, 0)

or just GetFieldSelections(FieldName) = 'c'

Hope this helps you.

Regards,

Jagan.

Re: how to make a chart visible based on the value selected?

Fri, 13 Dec 2013 05:57:53 GMT

PFA Hope this will help you

Re: how to make a chart visible based on the value selected?

Fri, 13 Dec 2013 06:01:25 GMT

PFA,

This would help you

Re: how to make a chart visible based on the value selected?

Fri, 13 Dec 2013 06:03:32 GMT

What if I select a and b multiple selection or any combination between the three values it should show both the charts.. but here I can do only one selection..

Regards,

Prajna

Re: how to make a chart visible based on the value selected?

Fri, 13 Dec 2013 06:04:31 GMT

I can't open the document as em using personal edition:(

Regards,

Prajna

Re: how to make a chart visible based on the value selected?

jagan — Fri, 13 Dec 2013 06:08:29 GMT

Hi,

Then try like this

=SubStringCount('|' & Concat(distinct FieldName, '|') & '|', '|*|')

Replace * with your value a/b/c in above expression

Regards,

Jagan.

Re: how to make a chart visible based on the value selected?

Fri, 13 Dec 2013 06:19:24 GMT

But by default all the 3 chart is visible when I give clear all. Cant I make it visible on selection only?

I tried

SubStringCount('|' & Concat(distinct Metrics, '|') & '|', '|a|')

SubStringCount('|' & Concat(distinct Metrics, '|') & '|', '|b|')

SubStringCount('|' & Concat(distinct Metrics, '|') & '|', '|c|')

Regards,

Prajna

Re: how to make a chart visible based on the value selected?

jagan — Fri, 13 Dec 2013 06:28:38 GMT

Hi,

Try like this

=SubStringCount('|' & GetFieldSelections(Metrics, '|') & '|', '|a|')

Regards,

Jagan.

Re: how to make a chart visible based on the value selected?

NareshGuntur — Fri, 13 Dec 2013 06:44:54 GMT

Hi Prajna,

You can use the below statement in the conditional(Layout tab)

FindOneOf( GetFieldSelections(Show), 'a') > 0

FindOneOf( GetFieldSelections(Show), 'b') > 0

FindOneOf( GetFieldSelections(Show), 'c') > 0

Here even if you select both a and b, the first and second charts will be shown and if you select all the 3, all the charts will be shown. But if you don't select anything no chart will be shown.

Hope this fulfils your requirement

Best Regards,

Naresh

Re: how to make a chart visible based on the value selected?

Fri, 13 Dec 2013 07:58:43 GMT

some error near letter show

FindOneOf( GetFieldSelections(Show), 'a') > 0

In place of show I need to put field name?

If so...

Em not able to hide the charts...all 3 are visible without data

Regards,

Prajna

Re: how to make a chart visible based on the value selected?

tresB — Fri, 13 Dec 2013 08:04:37 GMT

Have you tried ?

SubStringCount(GetFieldSelections(Metrics), 'a')

SubStringCount(GetFieldSelections(Metrics), 'b')

SubStringCount(GetFieldSelections(Metrics), 'c')

Re: how to make a chart visible based on the value selected?

Fri, 13 Dec 2013 08:06:05 GMT

Thanks for all the suggestions

Regards,

Prajna