Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to ignore a dual value in set analysis but it does not seem to be working
Sum({<[Fact_Type] ={'O'}, Year = {'$(vCurrYearNum)'}, MonthNum = {'$(vCurrMonthNum)'},Month =,[WeekName]= >} Opening_Base)
Month is the dual field here. The set analysis above gives the KPI for the current month. I have a line chart which shows Opening Base by month. If user selects a month, I don't want the KPI to change as this should always reflect the current months number. WeekName is working fine
are you sure Month is the selected month field name ?
Hi Sandeep,
You sure, you have used the month field correctly.
Because we have function with the name Month as well.
Try using -
Sum({<[Fact_Type] ={'O'}, Year = {'$(vCurrYearNum)'}, MonthNum = {'$(vCurrMonthNum)'},[Month] =,[WeekName]= >} Opening_Base)
Cheers!
Hi Rajesh
I tried putting [Month] but does not work. Something to do with dual as Month is defined as below
Month(DateID) as Month
Instead if I use MonthNum which is defined as below it works
num(Month(DateID)) as MonthNum
To add further to the issue, if I
1. Create Line chart using Month dimension as a field then it works
2. Create a Master Item Month using Month field, then use Master Item in the line chart, then it does not work
Hi Sandeep,
Can you plerase share a sample app.
Regards,
Rajesh
Hi Sandeep,
Please try this -
Sum({<[Fact_Type] ={'O'}, Year = {"$(=$(vCurrYearNum))"}, MonthNum = {"$(=$(vCurrMonthNum))"},[Month] =,[WeekName]= >} Opening_Base)
Regards
Rajesh