Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
fheidenstecker
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
crusader_
Partner - Specialist
Partner - Specialist

Hi,

What result do you expect to get?

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

Regards,

Andrei

fheidenstecker
Creator II
Creator II
Author

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)

crusader_
Partner - Specialist
Partner - Specialist

So then use this expression in the title

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

Edit: PFA

Regards,

Andrei

fheidenstecker
Creator II
Creator II
Author

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.

crusader_
Partner - Specialist
Partner - Specialist

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

Marcellino_Groothof
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.