Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sandygather
New Contributor II

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
Honored Contributor II

Re: Ignore dual value in set analysis

are you sure Month is the selected month field name ?

rajeshthakur292
Contributor II

Re: Ignore dual value in set analysis

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!

sandygather
New Contributor II

Re: Ignore dual value in set analysis

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

sandygather
New Contributor II

Re: Ignore dual value in set analysis

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

rajeshthakur292
Contributor II

Re: Ignore dual value in set analysis

Hi Sandeep,

Can you plerase share a sample app.

Regards,

Rajesh

rajeshthakur292
Contributor II

Re: Ignore dual value in set analysis

Hi Sandeep,

Please try this -

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

Regards

Rajesh