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.
If they don't show up after checking these 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
are you getting some sort of a total row at least? or just nothing at all?
Hi Nihhal ,
1. Please confirm table is straight table or Pivot.
2. If it is a straight table Go to Expression Tab select the particular Expression and in Total Mode Select
Sum as Total.
3.Go to Presentation Tab Select Particular Expression and in Totals Select Totals on Last Row.
4. Apply and OK.
Because i am using expresion in variable and that variable is being used in if condition in expression tab. So there is no aggregation funtion, i am suspecting this is the issue.
And i try to use aggregation function istead of variabl exp. However i am using set analysis in variable exp. So i want to use sum (aggr functions) mandatory there.
I hope you understand.