Expression Total in Barchart vs Straight Table

[krishna20]

Hi Folks,

I am not getting Totals as same as in both Bar chart and Straight table.  I need to get the expression TOTAL in bar chart as in straight table I am getting the right values .  I have tried Above (), Rangesum(), Rowno(TOTAL) but no luck.

I have two dimensions 

1. Calendar Year

2. =If(Received_Date<=Max(Calendar_Date) and Investigation_Date >Max(Calendar_Date), 'Pending', Status)

Expression:

Count({<Flag={'Esc_Dt'},Calendar_Date={">=$(=Date(Num(YearStart(Max(Calendar_Date),-3)),'DD-MM-YYYY'))<=$(=Date(Num(Max(Calendar_Date)),'DD-MM-YYYY'))"}>}DISTINCT ID)

@sunny_talwar  @marcus_sommer @Gysbert_Wassenaar 

Can anyone suggest how to achieve this. 

Regards

Krishna

[marcus_sommer]

Take a look on the TOTAL mode within the expression tab (bottom right area) of the straight-table if you could change them. If not you would need some adjustments to your logic - data-model and/or the UI - because you would need to enforce to sum the counts on the appropriate dimensionality with an aggr(), like:

sum(aggr(count(), Dim1, Dim2))

but the dimensions in this case must be native ones and not calculated dimensions. 

[krishna20]

Hi @marcus_sommer ,

Thanks for your reply. I am completely looking for the solution in Bar chart not in straight table. I need the totals which is showing in straight table that are needs to be shown in Bar chart as well.

[marcus_sommer]

Then take the same look on the TOTAL mode but within the bar-chart - changeable? And if returned it the expected results? Beside of this I'm not sure if it's expedient if both objects are showing a TOTAL - especially if the TOTAL calculation don't return the sum of rows which may the correct result for the business case but quite often are the users confused by such view (personally I would avoid it to not answer the same questions again and again). 

[Vargast534]

Straight Tables are most widely used sheet object to display data in QlikView. Kroger Eschedule They are very simple yet powerful with features like column rearrangement, sorting and coloring the background etc.