topic Re: Value on data points different than expression result in QlikView

Value on data points different than expression result

Wed, 30 Apr 2014 09:10:14 GMT

Hello,

I have a graph with one dimension and 2 expressions:

Expression 1 = % of Open Invoice/Order

count({<STATUS = {'Open'}>} ID) / count(ID)

Expression 2 = % of Closed Invoice/Order

count({<STATUS = {'Closed'}>} ID) / count(ID)

I want to display in the bars, the count of Open Invoice/Order and Closed Invoice/Order.

I know how to do it when I have one expression but it does not work with multiple expressions. I tried the "show value" attribute of expressions but it only allows to decide if the value should be displayed or not, I cannot put a different calculation.

Anybody would know how I can achieve below result without changing the dimension/expression implementation?

Thanks,

Re: Value on data points different than expression result

jagan — Wed, 30 Apr 2014 09:31:30 GMT

Hi,

Please find attached file for solution.

Regards,

Jagan.

Re: Value on data points different than expression result

Wed, 30 Apr 2014 10:03:26 GMT

Hello Jagan,

Unfortunately my real application is more complicated and I cannot add a second dimension to my graph.

Any other way to get what I am looking for?

Thanks,

Re: Value on data points different than expression result

Wed, 30 Apr 2014 10:12:16 GMT

The only way I can see you achieving this is to add two more expressions that are the count of the closed and open and then split the Axis .. as attached

Re: Value on data points different than expression result

jagan — Wed, 30 Apr 2014 10:15:49 GMT

Hi,

I think it is not possible with 1 Dimension.

Regards,

Jagan.

Re: Value on data points different than expression result

sudeepkm — Wed, 30 Apr 2014 10:22:07 GMT

please take a look at the example.

Re: Value on data points different than expression result

Wed, 30 Apr 2014 10:30:30 GMT

I do not think it is very readable.

If the graph behaviour is under total control, I thought of adding "Text in chart" on each bar. Otherwise I will need to review my dimension/expressions organization.

Thanks for trying guys.

Re: Value on data points different than expression result

Wed, 30 Apr 2014 10:32:03 GMT

The user wants the Y-axis to be in % but this is an interesting workaround.

Re: Value on data points different than expression result

jagan — Wed, 30 Apr 2014 10:45:08 GMT

Hi,

Instead you can create two charts for showing % in one chart and numbers in another chart.

Regards,

jagan.

Re: Re: Value on data points different than expression result

sudeepkm — Wed, 30 Apr 2014 11:05:18 GMT

if you want both the numbers and % then you ca split axis in same chart to have both displays in two sections. top and bottom.