topic Re: Reverse Block Chart in QlikView

Reverse Block Chart

Mon, 22 Jul 2013 19:33:35 GMT

Hello everyone,

I am currently creating a Block Chart using showing the average time it takes to do an activity by different disciplines. I would like to have my block chart in reverse, meaning that the smaller the average duration the bigger the box. Is this possible in qlikview?

Re: Reverse Block Chart

Anonymous — Mon, 22 Jul 2013 19:41:11 GMT

1/avg()

Re: Reverse Block Chart

Mon, 22 Jul 2013 19:44:40 GMT

That would work, but I would still want it to show the exact number. Here is an example that may help.

Average Duration to Perform Activity

-Engineering: 10 Days

-Procurement: 5 Days

-Construction: 3 Days

I would want a block chart with three blocks, Construction having the largest and the data inside the box showing "Construction (3)".

Does that help?

Re: Reverse Block Chart

Anonymous — Mon, 22 Jul 2013 20:29:09 GMT

A rather strange request, it looks counterintuitive... Something like this can be done with a pie chart:

One expression is 1/avg()

Second expression is avg(), with "values on data points" checked.

There is no such options for a block chart. Best I can think of - use "text as pop-up" for the second expression.