topic On Click Expand in QlikView

On Click Expand

Thu, 06 Oct 2016 06:16:45 GMT

Dear All,

Can we do this in Qlikview ?

In the above image there are 9 Expressions. I need to group it.

Lets say Gross, Gross Units and Sold Area into one Group.

On Click of Gross , Gross Units and Sold Area has to expand.

Let me know if you need any other details.

Regards,

Keerthi KS

Re: On Click Expand

marcus_sommer — Thu, 06 Oct 2016 06:21:44 GMT

This isn't possible. Alternatives could be to use expression-groups and cycling through different expressions per circle-icon or the use of separate buttons which switch a variable-value which is used as visibility-condition for the expressions.

- Marcus

Re: On Click Expand

jagan — Thu, 06 Oct 2016 07:09:33 GMT

Hi,

You have to create a Island table and need to use this as dimensions, then in the expression based on the dimension you have to give your expression.

LOAD

INLINE [

Group, KPI

Group1, Gross

Group1, Gross Units

Group1, Sold Area

Group2, KPI1

Group2, KPI2];

Expression: If(KPI = 'Gross', Gross Expression,

If(KPI = 'Gross Units', Gross Units Expression,

Like this you have to write single expression for all the KPIs.

Hope this helps you.

Regards,

Jagan.