topic I need to select Absolute and realative (%) in the same chart in QlikView

I need to select Absolute and realative (%) in the same chart

Thu, 05 Aug 2010 12:03:51 GMT

Hi,

I need to show absolute and realtive values in the same chart. Realtive mean (%) values how this can be achieved. I have a list box taht showas Absolute or relative for selecting.

Nanda.

I need to select Absolute and realative (%) in the same chart

kji — Thu, 05 Aug 2010 12:23:48 GMT

Assuming you want to show it as Value on Datapoints, make your expression something like:

Dual( Sum(Sales) & ' (' & Num(Sum(Sales) /Sum(TOTAL Sales) ,'0.00%') & ')', Sum(Sales) )

I need to select Absolute and realative (%) in the same chart

Thu, 05 Aug 2010 13:27:55 GMT

Something like this

I need to select Absolute and realative (%) in the same chart

Thu, 05 Aug 2010 15:05:29 GMT

Hi,

I did not explain clearly.My apologies. I do not want in the same chart but in different chart. I have to create a list box and when user selects absolute it should show numbers and, it Relative is selected it should show percentages(%) . I hope I expalined this time atleast.

Thanks again.

Nanda.

I need to select Absolute and realative (%) in the same chart

Thu, 05 Aug 2010 15:05:47 GMT

Hi,

Thanks again.

Nanda.

I need to select Absolute and realative (%) in the same chart

Thu, 05 Aug 2010 16:35:29 GMT

A simple solution is to have two charts - one on top of the other and then use conditional show to switch between them based on the selection.

So graph 1 will show relative expression and graph 2 will show absolute expression. Simply enter the following in the conditional show:

=only(field name) = 'Relative' for graph 1

=only(field name) = 'Absolute' for graph 2

That should work.

I need to select Absolute and realative (%) in the same chart

Thu, 05 Aug 2010 19:45:25 GMT

Here it is