Set Analysis Expression issue

[berryandcherry6]

Hi,

I have a Expression

Count({$<DateType={completion},final_test_status={"passed"},

YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"}>}invitation_id)

For this i am adding to filter it by  Canonical_Month={'Month_Last_Canon_Year'} .

Canonical_Month    Month_Last_Canon_Year

       Jan                                 May

       Feb                                 June  

      MAr                                  July

       Apr                                  Aug

      MAy

      June

       July

       Aug

        Sep

        Oct

        Nov

        Dec

So my expression becomes 

Count({$<DateType={completion},final_test_status={"passed"},

YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"},Canonical_Month={'Month_Last_Canon_Year'}>}invitation_id)

But  this Canonical_Month={'Month_Last_Canon_Year'}  is not getting applied. Count gives Zero.

Please help me on this.

[Gysbert_Wassenaar]

The Canonical _Month field contains values like 'Jan' and 'Feb'. It does not contain a value 'Month_Last_Canon_Year'.

Perhaps (though I doubt it) this works:

Count({$<DateType={completion},final_test_status={"passed"},

YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"},Canonical_Month={"=Canonical_Month=Month_Last_Canon_Year"}>}invitation_id)

[berryandcherry6]

Hi,

Thanks for reply

With or without  condition of Canonical_Month={"=Canonical_Month=Month_Last_Canon_Year"} gives same counts

[Gysbert_Wassenaar]

Thought as much. Try putting that condition in an if statement: count({...etc...}if( Canonical_Month=Month_Last_Canon_Year, invitation_id))

[berryandcherry6]

Hi,

This gives me some large number,Not valid count

count({<DateType = {invitation},

YOY_Canon_Year = {"$(=year(max(CanonicalDate))-1)"}>}if( Canonical_Month=Month_Last_Canon_Year, invitation_id))

[Gysbert_Wassenaar]

Post a small qlik sense app that demonstrates the problem.

[berryandcherry6]

Are you asking for Qvf file?

[Gysbert_Wassenaar]

Yes

[berryandcherry6]

Please see the attached file

[Gysbert_Wassenaar]

Please post a smaller qlik sense app that demonstrates the problem