Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Is this possible in QV?

Capture.PNG.png

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

Tags (2)
9 Replies
Highlighted
Not applicable

Re: Is this possible in QV?

What dimensions do you have in this chart?

Highlighted
Esteemed Contributor

Re: Is this possible in QV?

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

try using your dimensions and expression

hope this helps

Highlighted
Valued Contributor

Re: Is this possible in QV?

You can do it with a simple barchart:

barchart.png

Check attachment to see how...

Highlighted

Re: Is this possible in QV?

Yes by Bar chart this is possible.

Highlighted
Not applicable

Re: Is this possible in QV?

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.

Highlighted
Not applicable

Re: Is this possible in QV?

Dimensionless.

Highlighted

Re: Is this possible in QV?

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

regards

Marco

Highlighted
Valued Contributor

Re: Is this possible in QV?

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.

Highlighted
Not applicable

Re: Is this possible in QV?

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