Discussion board where members can get started with Qlik Sense.
I need some help with the following problem in Qliksense.
I'm loading an excel with the following data:
Name | Expense
A | $35
B | $10
A | $20
B | $25
C | $15
And I would like to put it into a table that consolidates all the unique Names:
A | $55
B | $35
How do I perform this in Qliksense?
Go to Solution.
you can do also in script as below:
Sum(Expense) as Expense
FROM yourTable Group By Name;
in your chart object you can use:
Name as dimension
Expense as Measure
create a simple table in qlik sense (in the sheet not the script)