Ignore dual value in set analysis

[Anonymous]

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

[agigliotti]

are you sure Month is the selected month field name ?

[Neymar_Jr]

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!

[Anonymous]

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

[Anonymous]

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

[Neymar_Jr]

Hi Sandeep,

Can you plerase share a sample app.

Regards,

Rajesh

[Neymar_Jr]

Hi Sandeep,

Please try this -

Sum({<[Fact_Type] ={'O'}, Year = {"$(=$(vCurrYearNum))"}, MonthNum = {"$(=$(vCurrMonthNum))"},[Month] =,[WeekName]= >} Opening_Base)

Regards

Rajesh