Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

berryandcherry6
Contributor II

Set Analysis Expression issue

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.

Tags (2)
10 Replies

Re: Set Analysis Expression issue

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)


talk is cheap, supply exceeds demand
berryandcherry6
Contributor II

Re: Set Analysis Expression issue

Hi,

Thanks for reply

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

Re: Set Analysis Expression issue

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


talk is cheap, supply exceeds demand
berryandcherry6
Contributor II

Re: Set Analysis Expression issue

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))

Re: Set Analysis Expression issue

Post a small qlik sense app that demonstrates the problem.


talk is cheap, supply exceeds demand
berryandcherry6
Contributor II

Re: Set Analysis Expression issue

Are you asking for Qvf file?

Re: Set Analysis Expression issue

Yes


talk is cheap, supply exceeds demand
berryandcherry6
Contributor II

Re: Set Analysis Expression issue

Please see the attached file

Re: Set Analysis Expression issue

Please post a smaller qlik sense app that demonstrates the problem


talk is cheap, supply exceeds demand