Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
CLH-Frank
Contributor
Contributor

GetFieldSelections returns Formula

Hello Community,

 

i use a Sum with Set-Expression:

Sum({$<Jahr={"=$(=getfieldselections(Jahr))"},Periode= {"<=$(=getfieldselections(Periode))"},Werttyp={'Ist'}>}Wert)

It works fine, when in the Filters for the Fields "Jahr" and "Periode" Values are selected.

 

When i use Formulas in the Filter-Fields:

Field "Jahr": =Jahr=Year(Today())

Field "Periode": =Periode=Month(Today())

there is following Output for the Formula: 

CLHFrank_0-1721985031319.png

and the KPI is no longer calculated. It is 0.

Has someone the same issue or an Solution for me?

 

For Info: We want to use the Formulas in a Bookmark to make it user-friendly easy to select the actual Year and Month for this Sheet.

 

Thanks and best regards, Frank

Labels (3)
2 Replies
Chanty4u
MVP
MVP

Try this 

Sum(

    {$

        <Jahr={"$(=Year(Today()))"},

        Periode={"<=$(=Month(Today()))"},

        Werttyp={'Ist'}

    >} 

Wert)

CLH-Frank
Contributor
Contributor
Author

Hello  Chant4U

 

thank you, but this does not solve my problem.

We want to keep the Set-Expression in the KPI. So the user can select anything in the Filters.

 

Best regards Frank