topic Re: Sum expression in bar chart with multiple dimensions in App Development

Sum expression in bar chart with multiple dimensions

qlikuser22 — Wed, 26 Jan 2022 13:00:56 GMT

I have a bar chart which represents billing details. It consists of both positive and negative values which is stored in a dimension called Value_Type. Now if I use a filter to select Positive, then there is no change in the bar chart. I can see both positive and negative value.

If I select Value_Type = Positive, then only positive billing should be seen in the bar chart and vice versa.

The expression I used is,

Positive:

Sum({$<StoreID={"FO*"},Value_Type={'POSITIVE'}>}Sales)

Negative:

Sum({$<StoreID={"FO*"},Value_Type={'NEGATIVE'}>}Sales)

The expression is working perfectly but it doesn't display only Negative values when the Value_Tyype filter is used.

Br,

Nisha

Thanks in advance

Re: Sum expression in bar chart with multiple dimensions

anat — Wed, 26 Jan 2022 14:10:51 GMT

can you try conditional expression

if(GetFieldSelections( Value_Type)='POSITIVE',Sum({$<StoreID={"FO*"},Value_Type={'POSITIVE'}>}Sales),Sum({$<StoreID={"FO*"},Value_Type={'NEGATIVE'}>}Sales))

Re: Sum expression in bar chart with multiple dimensions

qlikuser22 — Wed, 26 Jan 2022 14:43:08 GMT

Thanks for your reply. Unfortunately it is not working. I can see only negative values in bar chart.

Re: Sum expression in bar chart with multiple dimensions

anat — Wed, 26 Jan 2022 15:48:55 GMT

if possible can u share sample data

Re: Sum expression in bar chart with multiple dimensions

qlikuser22 — Fri, 28 Jan 2022 08:28:40 GMT

Hi @anat

I am sharing a sample data here

The vertical stacked bar chart with dimension as City and Measures as Positive and Negative value with respect to sales.

Thanks for your help.

Nisha