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: 
Not applicable

Money number format

Hi All,

Would it be possible in Qlik Sense to change dynamically the money format in a chart, when you select a currency?

meaning: I have 2 amounts one in USD and one in GBP. when I select the USD I would like to show the $ sing in the chart, when I select the GBP I would like to show the  £ sign.

Thanks in advance,

Francesco

1 Solution

Accepted Solutions
ahaahaaha
Partner - Master
Partner - Master

Hi Francesco,


Did a little work with your task (look attached file). Unfortunately, it was not possible to achieve a beautiful option. Formatting MONEY() works fine for only one currency option (see the expression in Table 1). As soon as I add the second condition for formatting the result, all the formatting disappears and the output is just a numeric representation (Table 2). I can not explain this behavior. Qlik Sense.

As a workaround, you can leave a numerical representation of the conversions, and synchronously change the currency with a choice in the text field above the chart (Table 3). I think this is a suitable option for visualization.


Regards,

Andrey

View solution in original post

7 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi Francesco,


Did a little work with your task (look attached file). Unfortunately, it was not possible to achieve a beautiful option. Formatting MONEY() works fine for only one currency option (see the expression in Table 1). As soon as I add the second condition for formatting the result, all the formatting disappears and the output is just a numeric representation (Table 2). I can not explain this behavior. Qlik Sense.

As a workaround, you can leave a numerical representation of the conversions, and synchronously change the currency with a choice in the text field above the chart (Table 3). I think this is a suitable option for visualization.


Regards,

Andrey

Not applicable
Author

Thank you very much for your suggestion

passionate
Specialist
Specialist

Hi Leoni,

You can also add this to your expression to get result:

Pick(Match(Country,'Australia','Finland'),Sum(Result)/Sum({1} Total Result)*100 &'$',Sum(Result)/Sum({1} Total Result)*100 &'€')

Change the parameters accordingly.

Thanks and Regards,

Pankaj

johnhubbard11
Contributor
Contributor

Good evening. I am also a fan of diversity in the casino, as it is very boring to play the same slots. I have been looking for a casino that has a decent selection of different games for so long and recently found https://tower.bet/wheel. Since it is in crypto games that I manage to earn a lot. Another advantage I can highlight is not a welcome bonus, but subsequent bonuses that are issued after the first deposit.

dariohill
Contributor
Contributor


@johnhubbard11 wrote:

Good evening. I am also a fan of diversity in the casino, as it is very boring to play the same slots. I have been looking for a casino that has a decent selection of different games for so long and recently found https://tower.bet/wheel.Drift Hunters Since it is in crypto games that I manage to earn a lot. Another advantage I can highlight is not a welcome bonus, but subsequent bonuses that are issued after the first deposit.


wow, that's really nice.

alexjohn234
Contributor
Contributor

I hate playing the same slots again again but Slotostock always helps me to find something new 

Rishel
Contributor
Contributor

If you're looking for some excitement and thrill, then Golden Reels Casino is the place to be. With an impressive selection of slot games to choose from, there's never a dull moment at this online casino. Whether you prefer classic fruit machines or modern video slots with amazing graphics and bonus features, Golden Reels has something for everyone. Plus, with https://goldenreels1.online/ user-friendly interface and seamless gameplay experience, spinning the reels has never been easier or more enjoyable. And don't forget about their generous bonuses and promotions that will keep you coming back for more. So why wait? Join the fun and start spinning those slots at Golden Reels Casino today!