topic Percentage and Value in a 2 Dim Chart in QlikView

Percentage and Value in a 2 Dim Chart

orital81 — Mon, 22 Jul 2013 13:48:01 GMT

Hi, I have a 2 Dim Bar Chart (MO# and Reason Code) where I would like to show % and Value.

The % should be Sum(Hours) aggregated by MO# and Reason Code devided by Sum(Hours) Aggregated by MO#

I am using the expression

Sum(Hours)/Aggr(Sum(Hours),MO#) But it seem to work only in certain cases

Please advice:

Which calculation should I use

How can I show both % and Value in the same Chart (I tried to set Righ and Left in the axes, didn't word) i

Attached the QVW

Thanks in advance

kaushiknsolanki — Mon, 22 Jul 2013 14:01:00 GMT

Hi,

Try =Sum(Hours)/sum(TOTAL<MO#> Hours)

But in a bar chart 2 dimension and 2 expression will not work.

You must remove one dimension or one Expression.

Regards,

Kaushik Solanki

orital81 — Mon, 22 Jul 2013 14:13:33 GMT

Great! Thanks a lot Kaushik