Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Toggle not working

Hi all , 

 

I have created a toggle .PFA the image. But some how toggle is not working.

 

Its giving only share metric value.

Please help.

 

Logic i am using

 

Num(
Round(
Sum(
{<
Report = {'General Campaign Data'},
Keyword =,
Currency =
>}

IF(Metric = 'Sales',
If([Currency Shown] = 'Euro', [Spend (€)], Spend),
If([Currency Shown] = 'Euro', [Sales (€)], Sales)))

, 1000) / 1000
, vFormatLocalCurrenciesRounded)

0 Replies