Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

msbhuvanesh003
New Contributor II

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
Honored Contributor III

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

You should use -

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


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

4 Replies
Digvijay_Singh
Honored Contributor III

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

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
Esteemed Contributor

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

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

msbhuvanesh003
New Contributor II

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

Thank you so much sir.

Highlighted
msbhuvanesh003
New Contributor II

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

Thank you so much omarbensalem‌.

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

Community Browser