Discussion board where members can get started with Qlik Sense.
Hi, I want to show the sum of a value of a dimension in a KPI. I have created the following hypothetical example to illustrate.
* Breakdown of North
What would be the best way to show the total sum of all sales in North, i.e., 956.376,34 € in the front end? My formula is
sum(if(Type='ComponentCVaR',Type,null())) but it is not working...
Since Type is a text value, you don't want to sum() this, right?
Try summing a numeric field.
What is Type here?
If Type is a text field it will not work.
You can try one of the following expressions (adapt according to your model):
Assuming you have a Field called "Sales" in your data that has both text and number.
For dimension: =Capitalize(KeepChar(lower(Sales),'abcdefghijklmnopqrstuvwxyz€'))
For expression: =sum(PurgeChar(lower(Sales),'abcdefghijklmnopqrstuvwxyz€'))
Sales is your field.
Use Pivot table extension and use
Dimension: Sales, Name
And use Subtotals.