Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Have you already chosen from one of these two options on the expression tab for all your expression? I hope it is not set to no totals
Yes i checked that option for all measures.
Note: I used list of measures as Dimension
Would you be able to share a sample? I am not sure I understand what you mean when you say list of measure as a dimension?
will you be able to share the sample file ??
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.
Hi Sunny, list of measures means:
Dimension has Revenue, Qty etc as values
I hope you understand.
Hi Ravi,
I am using flag in table like 1, 2.
If i do sum of row total should be more 2 (its depends on number of rows) so its wrong, total should be 1 or 2.
Hi Nihhal,
Else try
Go to Expression Tab select the particular Expression and in Total Mode Select
Expression Total.
Not working.
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.
Thanks,
Nihhal.