Money number format

[#1]

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

[ahaahaaha · Accepted solution]

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

[#3]

Thank you very much for your suggestion

[passionate]

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]

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]

---

@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]

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

[Rishel]

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!