topic Re: Queries regarding the sample model. in QlikView https://community.qlik.com/t5/QlikView/Queries-regarding-the-sample-model/m-p/1092655#M920782 <HTML><HEAD></HEAD><BODY><P>SPPrice table is connected with Transactions table.</P><P>The SPPrice table misses the SEP values for key - prucuct_key &amp; TransDate.</P><P></P><P>See the picture below:</P><P><IMG alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122571_Screenshot_1.jpg" style="height: 283px; width: 620px;" /></P></BODY></HTML> Mon, 25 Apr 2016 06:09:45 GMT MindaugasBacius 2016-04-25T06:09:45Z Queries regarding the sample model. https://community.qlik.com/t5/QlikView/Queries-regarding-the-sample-model/m-p/1092653#M920780 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P></P><P>I have attached the sample model.</P><P>I have some queries regarding the model.</P><P></P><P>1.In the diagram , why the PREVIEW is inactive.<IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122573_Capture.PNG" style="height: 370px; width: 620px;" /></P><P></P><P></P><P></P><P>2. I have got I value in SPPrice . See the screenshot .</P><P><IMG alt="Capture2.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/122574_Capture2.PNG" style="height: 381px; width: 620px;" /></P><P></P><P></P><P></P><P>3. I cannot find out from where the null SEP is coming.<BR /><IMG alt="Capture1.PNG" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/122575_Capture1.PNG" style="height: 219px; width: 620px;" /></P><P></P><P>Please assist.</P><P>Sample qlikview model attached.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Queries-regarding-the-sample-model/m-p/1092653#M920780 suvechha_b 2020-11-25T16:16:04Z Re: Queries regarding the sample model. https://community.qlik.com/t5/QlikView/Queries-regarding-the-sample-model/m-p/1092654#M920781 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>check do you have SEP value on Trans Date </P><P>20160404</P><P>20160405</P><P>20160413</P><P>20160414</P><P></P><P>Note: Avoid synthetic table if you can.</P><P></P><P>Regards,</P></BODY></HTML> Mon, 25 Apr 2016 06:07:45 GMT https://community.qlik.com/t5/QlikView/Queries-regarding-the-sample-model/m-p/1092654#M920781 PrashantSangle 2016-04-25T06:07:45Z Re: Queries regarding the sample model. https://community.qlik.com/t5/QlikView/Queries-regarding-the-sample-model/m-p/1092655#M920782 <HTML><HEAD></HEAD><BODY><P>SPPrice table is connected with Transactions table.</P><P>The SPPrice table misses the SEP values for key - prucuct_key &amp; TransDate.</P><P></P><P>See the picture below:</P><P><IMG alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/122571_Screenshot_1.jpg" style="height: 283px; width: 620px;" /></P></BODY></HTML> Mon, 25 Apr 2016 06:09:45 GMT https://community.qlik.com/t5/QlikView/Queries-regarding-the-sample-model/m-p/1092655#M920782 MindaugasBacius 2016-04-25T06:09:45Z