X axis labels

[Marlen]

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.

[PradeepK · Accepted solution]

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!

[Marlen]

Thanks. It's working well