Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
dinicholls
Contributor II

Radar Chart & Selections

Hi all,

I have a radar chart in my app, that has 1 dimension, and expressions summing 'total debt', '>60 day debt', and '>90 day debt'.

The radar chart is great for displaying the info I want and need, but I would like to add a filter to the expressions, so that people can select if they want to see just 'total debt', or '>60 day debt' and '>90 day debt', but not 'total debt'.

Is there a way I can do this? Would I have to use some sort of inline table that link to a field in my script?

Thanks for your ideas / help

Di

3 Replies
qlikviewnovice
Valued Contributor II

Re: Radar Chart & Selections

Hi

Yes, you have to create Inline Table and link to the field

Partner
Partner

Re: Radar Chart & Selections

You can load a seperate table with a field, say

Load * Inline [UserSel

'total debt',

'>60 day debt',

'>90 day debt'

];


And then in your chart make the expressions conditional (right top corner in the expression tab) with an expression like

GetSelectedCount(UserSel)=0 or Only(UserSel)='total debt'

manucamon
Valued Contributor III

Re: Radar Chart & Selections

Hi Diane,

Create an inline table with your options. On your chart, on expressions tab, you can hide the expressions that you wanna see:

On condition write:

For totaldebt:

If(GetSelectedCount(YourNewInlineField)=0,True(),

     If(GetSelectedCount(YourNewInlineField)=1 and YourNewInlineField = 'total debt', True(),

          If(GetSelectedCount(YourNewInlineField)=2,True(),False())))

For non totaldebt:

If(GetSelectedCount(YourNewInlineField)=0,True(),

     If(GetSelectedCount(YourNewInlineField)=1 and YourNewInlineField <> 'total debt',', True(),

          If(GetSelectedCount(YourNewInlineField)=2,True(),False())))

Regards!!