Outer Join NULL value in SET expression - Challenge to All!
Hi Guys,
Sample QVW is attahced.
In file you will be able to see three categories of Pages Viewed; in Last 1Week (1WK), in last 4WK and in last 52WKS.
AU_ID is the join between these tables.
It is possible that a user has some pages viewed in last 52WKS but no pages viewed in last 4WKS and in last 1WK. (You will realize this when you see the total number of records in Pages Viewed in 52WKS field than others two)
If I query from DB that positive pages viewed in 52WKS but no pages viewed in 4WKS and in 1WK, DB will show me a record with page count for 52WKS and NULL for both 4WKS and 1WK.
I want similar report in Qilkview. that show me the records aginst different selections (as you will see on the left hand side of the sheet)
If expression give me the correct result but SET expression is not.
Chat tables for both types of expression IF and SET are created. but both show the different result especially when >=0 is selected.
Can some one look into that and figure out why results are dfferent in both charts.
My understanding is that SET expression is only giving records against those AU_ID which all three page counts type have some values. And not giving the records for those in which one or two have NULL values.
I hope I am clear. If not can you please let me know.
