topic Re: Expression Total in Barchart vs Straight Table in QlikView

Expression Total in Barchart vs Straight Table

krishna20 — Thu, 24 Aug 2023 07:27:24 GMT

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

Re: Expression Total in Barchart vs Straight Table

marcus_sommer — Thu, 24 Aug 2023 07:43:02 GMT

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.

Re: Expression Total in Barchart vs Straight Table

krishna20 — Thu, 24 Aug 2023 07:50:05 GMT

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.

Re: Expression Total in Barchart vs Straight Table

marcus_sommer — Thu, 24 Aug 2023 08:02:41 GMT

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).

Re: Expression Total in Barchart vs Straight Table

Vargast534 — Wed, 06 Sep 2023 20:49:43 GMT

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.