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: 
msbhuvanesh003
Contributor III
Contributor III

How to populate the multiple currency code in #1 KPI ( Qlik sense )

Dear Experts,

I have a bank dashboard ; inthat when I select the bank name in the list , the currency code will be USD and INR.

but the result is " - " ; I want both currenct code will be shown.

when the currency code is one the result is viewed correctly.

when the currency code is 2 the result is showed "-".

Ex:

Bank Name: State Bank of India

Currency Code in filter pane: INR,USD

the result should be = Currency code : INR,USD

1 Solution

Accepted Solutions
Digvijay_Singh

You should use -

GetFieldSelections ( Currency,',') instead of CUrrency.


When Currency will have >1 selections, you need to use some aggregation to combine your result.

View solution in original post

4 Replies
Digvijay_Singh

You should use -

GetFieldSelections ( Currency,',') instead of CUrrency.


When Currency will have >1 selections, you need to use some aggregation to combine your result.

OmarBenSalem

use: concat( distinct CurrencyCode, ', ') instead of directly calling CurrencyCode

msbhuvanesh003
Contributor III
Contributor III
Author

Thank you so much sir.

msbhuvanesh003
Contributor III
Contributor III
Author

Thank you so much omarbensalem‌.

I m new to this platform (Qlik Sense) so I need ur supports...