topic Re: Is this possible in QV? in QlikView

Is this possible in QV?

Fri, 16 May 2014 14:32:13 GMT

I want to have all boxes and lines to dynamically size based on filters selected by the user.

I can manage the bars easily in 2 charts or even 1 chart but the % metrics are hard to dynamically size based on selections and peg them to the height of the associated bars.

As I understand, there is no way to horizontally offset bars in QV only vertically i.e. you cannot offset it by X-axis but only by Y-axis value

Re: Is this possible in QV?

Sat, 17 May 2014 09:24:10 GMT

What dimensions do you have in this chart?

Re: Is this possible in QV?

SunilChauhan — Sat, 17 May 2014 15:32:39 GMT

i thing this can be achieved using block chart available in qlikview

try using your dimensions and expression

hope this helps

Re: Is this possible in QV?

luciancotea — Sat, 17 May 2014 17:20:37 GMT

You can do it with a simple barchart:

Check attachment to see how...

Re: Is this possible in QV?

its_anandrjs — Sat, 17 May 2014 18:55:03 GMT

Yes by Bar chart this is possible.

Re: Is this possible in QV?

Sat, 17 May 2014 22:28:57 GMT

Hi guys,

thanks for your responses, but this doesn't resolve the question since my chart is dimensionless and I need % metrics for the C & D blocks with a height pegged to the C and D bars.

I don't think this is solvable in QV.

Re: Is this possible in QV?

Sat, 17 May 2014 22:29:25 GMT

Dimensionless.

Re: Is this possible in QV?

MarcoWedel — Sun, 18 May 2014 00:28:19 GMT

Match() / ValueList() could solve the dimension issue

regards

Marco

Re: Is this possible in QV?

luciancotea — Sun, 18 May 2014 06:12:45 GMT

That's exactly what I did: C + D = 25, but they were refitted to match the height of the lower B block (= 20).

And yes, you do have dimensions.

Re: Is this possible in QV?

Sun, 18 May 2014 11:27:55 GMT

What you have in this case is introduced dimensions, which is fine, however, I need to have the % metrics visible on the object as opposed to on a tooltip.

Also, that I need to have every expression with a different definition.

for eg. A = All Sales, B = Sales for a subset, C = a further filtered subset