Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mark_manalo
New Contributor

set analysis formula works in textobject but not in LOAD SCRIPT

I have the following formula in a Text Object:

    =Num(Sum(Aggr(Count({<Jahr={$(vTodayYear)}, Kw={">=1<=$(vTodayKw)"}, Database.Kennzahl={'Ew'}, Database.Szenario={'Actual'}>} DISTINCT Database.MitarbeiterID), Kw) /  vTodayKw) , '###.##0')

This works and it gives me the desired Value. But when I want to SET it to LOAD SCRIPT like this:

    SET vMyVar = =Num(Sum(Aggr(Count({<Jahr={$(vTodayYear)}, Kw={">=1<=$(vTodayKw)"}, Database.Kennzahl={'Ew'}, Database.Szenario={'Actual'}>} DISTINCT Database.MitarbeiterID), Kw) /  vTodayKw) , '###.##0');

This doesn't work and theres no ErrorMessage

Thanks for any help!

1 Reply

Re: set analysis formula works in textobject but not in LOAD SCRIPT

How you are calling in Text object? vMyVar Instead use $(vMyVar)

Life is so rich, and we need to respect to the life !!!
Community Browser