Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Chart Expression

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.

1 Solution

Accepted Solutions
erich_shiino
Honored Contributor

Chart Expression

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

7 Replies
erich_shiino
Honored Contributor

Chart Expression

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

Not applicable

Chart Expression

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

erich_shiino
Honored Contributor

Re: Chart Expression

Hi,

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

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

Regards,

Erich

rahulgupta
Contributor III

Re: Chart Expression

Hey hi,

Kindly find the attached file...

Hope this find your solution....

Not applicable

Chart Expression

I tried this again at it works. Thanks

rahulgupta
Contributor III

Chart Expression

My Pleasure....!!

Not applicable

Re: Chart Expression

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

Community Browser