Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Qliksense ODAG

Hi,

I have one requirement to convert all charts/kpis in my qliksense dashboard numbers from millions to thousands based on countries selection as some countries will always have less revenue/sales. 

Can we achieve this through ODAG option in qliksense ?

We are in search for other alternative ideas to achieve this, instead of keeping toggle button for conversion.

Please suggest if anyone has any ideas on this.

Labels (1)
2 Replies
Highlighted
Partner
Partner

A tricky method is use "+0" in the end formula and "Auto" option selected to force system abbreviations.

 

Examples:

Sum(Field)+0

$(vFormula)+0

 

Support your colleagues. Remember to "like" the answers that are helpful to you and flag as "solved" the one that helped you solve. Cheers.
Highlighted
Contributor III
Contributor III

Yes ,this can be achieved with ODAG.