https://community.qlik.com/t5/QlikView/Design-issue/m-p/1692981#M726973 <P>hi guys</P><P>Please find attached.&nbsp;</P><P>this is so simple, I cant believe I'm battling with it...In the attached model i have Customer Names and Sales for certain Channels. Note - I always ONLY want to see where Date_Selector = Last 3 days.</P><P>e.g. Woody has a Volume of 3 for the 12th. Peter has nothing for the last 3 days BUT I want to see that he has nothing...</P><P>How do I do it? it would have been simple if I could just ignore the last requirement - to see where all 3 days are Zero as well,...you will see in my code I have been able to "catch" the Null Volume, but how would I be able to "get" the "Full_Name as its on the "wrong" side of the join...</P><P>This is an urgent requirement please.</P><P>Thank you!</P> Wed, 25 Nov 2020 16:16:04 GMT QFanatic 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Design-issue/m-p/1692981#M726973 <P>hi guys</P><P>Please find attached.&nbsp;</P><P>this is so simple, I cant believe I'm battling with it...In the attached model i have Customer Names and Sales for certain Channels. Note - I always ONLY want to see where Date_Selector = Last 3 days.</P><P>e.g. Woody has a Volume of 3 for the 12th. Peter has nothing for the last 3 days BUT I want to see that he has nothing...</P><P>How do I do it? it would have been simple if I could just ignore the last requirement - to see where all 3 days are Zero as well,...you will see in my code I have been able to "catch" the Null Volume, but how would I be able to "get" the "Full_Name as its on the "wrong" side of the join...</P><P>This is an urgent requirement please.</P><P>Thank you!</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Design-issue/m-p/1692981#M726973 QFanatic 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Design-issue/m-p/1692989#M726974 <P>hi&nbsp;</P><P>if you want to display all values if a dimension&nbsp;</P><P>just check the box as in the picture below</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Annotation 2020-04-13 100713.png" style="width: 279px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/31734iE3F01FB2200B92E9/image-size/medium?v=v2&amp;px=400" role="button" title="Annotation 2020-04-13 100713.png" alt="Annotation 2020-04-13 100713.png" /></span></P> Mon, 13 Apr 2020 12:56:49 GMT https://community.qlik.com/t5/QlikView/Design-issue/m-p/1692989#M726974 lironbaram 2020-04-13T12:56:49Z