topic Chart Expression in QlikView

Chart Expression

Fri, 20 May 2011 15:00:49 GMT

We analyse our sales over different sourcing methods. In our report we want to show what is sold through the DD sourcing method, and what is sold through the other sourcing methods. In a chart we have two Expressions set up - If ([Sourcing Method] = 'DD', Sum([Line Value])) and If ([Sourcing Method] <> 'DD', Sum([Line Value])).

When selecting either sourcing method the line value for this is shown under the right heading. However, when selecting both Sourcing Methods both figures are shown in the Other Sourcing method total - none is shown under DD.

Chart Expression

erichshiino — Fri, 20 May 2011 15:35:12 GMT

What happens when you include the sourcing method as a dimension on your chart? Then you could avoid the if-condition.

another option would set-analysis.

Try these:

Sum( {<[Sourcing Method]*={DD}>} [Line Value] )

Sum( {<[Sourcing Method]=[Sourcing Method]-{DD}>} [Line Value] )

Hope it helps,

Erich

Chart Expression

Fri, 20 May 2011 15:47:56 GMT

Thanks for that. However using your suggestion if I select the sourcing methods other than DD there are no figures where I know there should be.

I didn't have the Sourcing Method in the Dimensions but if I do the suggestion still doesn't give the results.

Ian

Re: Chart Expression

erichshiino — Fri, 20 May 2011 16:19:08 GMT

Hi,

I don't understand why it didn't work.

Please, check my attachment (I may have misunderstood your problem)

Regards,

Erich

Re: Chart Expression

rahulgupta — Sat, 21 May 2011 06:31:40 GMT

Hey hi,

Kindly find the attached file...

Hope this find your solution....

Chart Expression

Tue, 24 May 2011 07:19:13 GMT

I tried this again at it works. Thanks

Chart Expression

rahulgupta — Tue, 24 May 2011 08:38:19 GMT

My Pleasure....!!

Re: Chart Expression

Sun, 23 Sep 2018 00:04:13 GMT

What happens when you include the sourcing method as a dimension on your chart? Then you could avoid the if-condition.