Show the cumul value and ignoring dimension

[beck_bakytbek]

Hi Folks,

i got a question, my data look like this:

Month, Yalue

1, 3

2, 10

3, 15

is that possible to create the expression to show cumul value and at the same time to ignore dimensin. my expected output is:

Value  28

Month, 3

Now i have this view

Value, 3, 10, 15

Month, 1, 2, 3

i want to show within my barchart only this view:

Value  28

Month, 3

Does anybody have any idea how to resolve this issue?

Thanks a lot

[rwunderlich]

Dimension: Max(Month)

Measure: Sum(Value)

-Rob

[beck_bakytbek]

Rob thanks a lot for your reply and time,

i have a question, what if, i have 2 expression: with one 1 expression i want to show all values for each month, and with second expression: i want to show my cumul.value = 28. for instance:

Dim: Month                                  1 , 2, 3

1 Expr (Sum (Budget))             5, 7, 12

2 Expr (Sum (Expenses))          -, -, 28

if i have the 2 expressions, then i can not to use the Dim (Month) = Max(Month).

i hope i explaned well, do you have idea how to resolve this issue? Thanks a lot

[rwunderlich]

You will want to use the TOTAL keyword to ignore dimension in this expression. 

(Sum (TOTAL Expenses))

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/BasicAggr...

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[beck_bakytbek]

Hi Rob 

thanks a lot for your time and feedback, i implemented your suggestion, but it does not work (see screenshot)

Do you have any ideas?

Thanks a lot

[rwunderlich]

I'm not understanding. The second expression (red bar) seems to be showing total expenses.  Can you draw a sketch of what you are looking for?

-Rob

[beck_bakytbek]

Hi Rob,

thanks a lot for your reply,

i want to have the red bar as total only in month: Mar 21 =  Value = 28.  like this (see screenshot)

Thanks a lot

Bek

[rwunderlich]

For the cumulative expenses bar try:

if (Dim = max(TOTAL {<Dim = {"=Expenses > 0"}>} Dim), Sum(TOTAL Expenses))

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[beck_bakytbek]

Hi Rob, again thanks a lot for your time and your help,

i implemented your suggestion: 

but this expression does not work (see screenshot)

or am i missing something ?

Thanks a lot

Bek

[MayilVahanan · Accepted solution]

HI @beck_bakytbek 

Might be, try like below

If(Dim =Maxstring({<Dim={"=Sum(Expenses)>0"}>}Total Dim), Sum(Total Expenses))