topic Re: Group expressions in rows to allow expand/collaps function in QlikView

Group expressions in rows to allow expand/collaps function

Fri, 16 Jun 2017 11:32:32 GMT

Hello,

Is it possible to group expressions and then be able to expand collaps them in a pivot table (like you can do with dimensions)

So, in below picture I have an expression for each row. I would like to be able to group Quant var dir mat --> stock-taking, cost as they sum up to mat and procurem var and then be able to expand/collaps with +/- symbol.

Is there an easy way to do this?

Re: Group expressions in rows to allow expand/collaps function

sunny_talwar — Fri, 16 Jun 2017 11:50:00 GMT

May be couple of ways

1) Create synthetic dimensions and add those expression as a dimension and use a single expression

2) May be create a text object with +/- sign and conditionally hide show expressions based on button click

Re: Group expressions in rows to allow expand/collaps function

Fri, 16 Jun 2017 12:01:23 GMT

Ok, not an answer I was hoping for

Neither options seems like good options for me as I would need quite a lot of them. Then I guess the users will have to live with fully expanded rows.

I was hoping there was a built in function that could solve it.

Thanks anyway Sunny.

Re: Group expressions in rows to allow expand/collaps function

sunny_talwar — Fri, 16 Jun 2017 12:04:03 GMT

Don't like the second option as well? Its not that difficult to do this...

Re: Group expressions in rows to allow expand/collaps function

kamal_sanguri — Fri, 16 Jun 2017 12:09:57 GMT

I totally agree that second option suggest ed by stalwar1‌ is quite practical and should be quickly to implement

Re: Group expressions in rows to allow expand/collaps function

Fri, 16 Jun 2017 12:19:20 GMT

Well, but I am afraid that the relative postion of +/- sign will be very confusing for the users if some are expanded and some are not.

See below. So If I would go for option 2 and have the table expanded, then the +/- sign will not be positioned next to the correct row, right?

Re: Group expressions in rows to allow expand/collaps function

sunny_talwar — Fri, 16 Jun 2017 12:24:36 GMT

You can use two buttons instead of 1... but yes it will not be as easy as an inbuilt thing....

Re: Group expressions in rows to allow expand/collaps function

kamal_sanguri — Fri, 16 Jun 2017 13:17:23 GMT

How about using two buttons, where one button will expand the Chart to fullest and other one will collapse it. You can a use a variable and set it to 0 or 1 on button/text box press actions and use this variable to show/hide two pivot chart (one which is fully expanded and other one would be the current chart you have.

Re: Group expressions in rows to allow expand/collaps function

kamal_sanguri — Fri, 16 Jun 2017 13:23:30 GMT

I mean, if you can consider placing those two text box/buttons not in the chart (so you don't have to worry about their relative position) may be above the chart (where it can attract user quickly)

Re: Group expressions in rows to allow expand/collaps function

Fri, 16 Jun 2017 13:29:50 GMT

Hello guys!

Ok, that would probably be better than nothing.

If you have time I would highly appreciate if you could tell me what to type in as conditional formula and how to link it to the +/-image

Re: Group expressions in rows to allow expand/collaps function

Fri, 16 Jun 2017 14:44:41 GMT

got it to work following this example

Thank you very much to both of you. Very helpful!!!

Button to Show/Hide a Calculated Dimension