topic Re: Dynamically adjusting row height based on column shown in pivot table in QlikView

Dynamically adjusting row height based on column shown in pivot table

chriscools — Thu, 01 Feb 2018 17:14:25 GMT

Hello,

i have a pivot table and 1 of the expressions is giving the picture of a product when the pivot table is totally folded out.

is it possible to have a row height of 1 as long as the pivot table is not folded out to the last level?

And only when the column with the productname is shown a row height of 4 should be used.

thanx!

Chris

chriscools — Sun, 04 Feb 2018 10:03:54 GMT

or is it possible to change row height using a variable?

Anil_Babu_Samineni — Sun, 04 Feb 2018 12:15:52 GMT

Not sure, What you are talking about respect variable? But, Are you looking this way

chriscools — Tue, 06 Feb 2018 08:52:39 GMT

Hello,

the "size to data" option is allready turned on but that doesn't help.

maybe because that only works for data and not an expression returning an image.

what i meant with a variable is that perhaps i could place an empty variable on the page, and when the pivot

table is folded out untill the lowest level (when i want to see the image) i could put the variable perhaps on "1",

and then the row height could be adjusted to another height...