Qlik Community

Ask a Question

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Use Column() in Chart Title

Hello Qlik Community,

is it possible to use the column function in the chart titel?

Obviously it works with expression, but it is not retourning a value if used in title 😞

Column.png

Maybe there is some trick or alternative ?

I attached a sample file and would appriciate some help 🙂

Cheers from Germany,

Fabian

7 Replies
Partner
Partner

Hi,

What result do you expect to get?

A Sales / Profit number? or text 100500 / 10000 means Sales / Profit ?

Regards,

Andrei

Creator II
Creator II

Andrei,

I would like to see the total margin, which should be like 0,19.

This would be the result of sum(Margin)/Sum(Sales)

Partner
Partner

So then use this expression in the title

=num(sum(Profit)/sum(Sales),'#,###.##','.',',') - help with formatting

Edit: PFA

Regards,

Andrei

Creator II
Creator II

Thanks Andrei, but this does not help me.

The problem is, I want to display the coloumns dynamically based on the user's choice and i was hoping to find an easy way to display the sums in the title.

I would like to avoid having to write a long if statement with all possible combiations of columns.

Partner
Partner

As I understood in your original app Customer can choose what to show in your charts, right?

Margin or smth else?

In this case I advice to use variables within getCurrentSelection() function to define wich measure is selected right now.

Hope this helps you.

Regards,

Andrei

Contributor III
Contributor III

Hi try this,

 

=' Profit: ' & num(sum(Profit) / sum(Sales),' ##,0%' )

Not applicable

Write the expression to handle user selections & get desired o/p.