Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I want to do something like this excel line chart with custom x axis labels:
4 measures, 1 date dimension and 1 measure (highlighted) as a label near the monthes.
Is it possible in qlik sense?
Thanks in advance.
Hi @Marlen
You can use Aggr() function..
Sample code for reference
Syntax - AGGR(<Measure>,<dim list>)
=Month & '(' & Aggr(Sum(Sales),Month) & ')'
Tip : Use Sort by expression for sorting related issue.
Hope this helps!
Hi @Marlen
You can use Aggr() function..
Sample code for reference
Syntax - AGGR(<Measure>,<dim list>)
=Month & '(' & Aggr(Sum(Sales),Month) & ')'
Tip : Use Sort by expression for sorting related issue.
Hope this helps!
Thanks. It's working well