Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Hi,
Thanks for reply
With or without condition of Canonical_Month={"=Canonical_Month=Month_Last_Canon_Year"} gives same counts
Thought as much. Try putting that condition in an if statement: count({...etc...}if( Canonical_Month=Month_Last_Canon_Year, invitation_id))
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))
Post a small qlik sense app that demonstrates the problem.
Are you asking for Qvf file?
Yes
Please see the attached file
Please post a smaller qlik sense app that demonstrates the problem