Solved: Totals in Straight Table - Qlik Community

nihhalmca · ‎2016-08-24

Hi All,

I want to display totals below straight table. There is any option like Totals on First row or Totals on Last row rather than expression.

If i would be resolved by expression itself, can you write it simple way.

Note: I used list of measures as Dimension.

Thanks,

Nihhal.

nihhalmca · ‎2016-08-25

I got solution as i used SUM in expression instead of using in variable, to get right data i used aggr with sum in variable (expression).

Fx:

sum(If(field ='A', $(vVariable))

sunny_talwar · ‎2016-08-24

Are you looking for this?

agomes1971 · ‎2016-08-24

Hi,

please see this article

HTH

André Gomes

stabben23 · ‎2016-08-24

Hi,

Why not keep it simple and use Total on first/last row? That use the Expression it self.

adamdavi3s · ‎2016-08-24

If they don't show up then close and re-open Qlik.

I spent ages trying to figure out why they wouldn't display but its a known 'feature' in Qlik12

avinashelite · ‎2016-08-24

Yes, we have go to >Chart Properties > Presentation > in the right hand side you could see the > Totals > select the option you want

ramasaisaksoft · ‎2016-08-24

Hi Nihha,

Presentation -> Totals-> Totals On Last Row will help to you to find totals.

nihhalmca · ‎2016-08-24

Hi Sunny, I tried this option however not showing values.

nihhalmca · ‎2016-08-24

Hi Ram sai, I tried this option however not working.

nihhalmca · ‎2016-08-24

not working, i am suspecting here that i used list of measures as Dimension.

Totals in Straight Table