Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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