Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Ignore dual value in set analysis

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

6 Replies
agigliotti
Partner - Champion
Partner - Champion

are you sure Month is the selected month field name ?

Neymar_Jr
Creator II
Creator II

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
Not applicable
Author

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
Not applicable
Author

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
Creator II
Creator II

Hi Sandeep,

Can you plerase share a sample app.

Regards,

Rajesh

Neymar_Jr
Creator II
Creator II

Hi Sandeep,

Please try this -

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

Regards

Rajesh