Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
manu1512
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