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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
dcdjei
Contributor
Contributor

Use Function to filter a dimension

I'm Trying to filter a measure using a formula that includes the GetFieldSelections() to filter the informasion ussing data that is selected in a different table that is not connected in the data model.

The expression that is not working is

if(Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'}, GetFieldSelections(MonthName) = {SignedMonth} >}ACVEur)=0,0,Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'} >}ACVEur))

 

If removed the expression without ", GetFieldSelections(MonthName) = {SignedMonth}" it is working but of course it is not filtering as expected.

 

Many thanks

Labels (1)
1 Solution

Accepted Solutions
vchuprina
Specialist
Specialist

Hi, 

Try this:

if(Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'},
SignedMonth = {"$(= GetFieldSelections(MonthName))"}
>}ACVEur)=0,0,Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'} >}ACVEur))

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

View solution in original post

1 Reply
vchuprina
Specialist
Specialist

Hi, 

Try this:

if(Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'},
SignedMonth = {"$(= GetFieldSelections(MonthName))"}
>}ACVEur)=0,0,Sum( {<OppType = {'New Sales'},ForecastCat = {'Won'} >}ACVEur))

Regards,

Vitalii

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").