topic Please help with intervals in QlikView App Dev
https://community.qlik.com/t5/QlikView-App-Dev/Please-help-with-intervals/m-p/1531443#M748203
<P>Good day!</P><P>I am looking for the solution.</P><P> </P><P>I have a table like TABLE_1 with sales contract parameters:</P><P>Client Min_Quantity Price</P><P>John 1 20 Eiro</P><P><SPAN>John 2 10 Eiro</SPAN></P><P><SPAN>John 5 5 Eiro</SPAN></P><P><SPAN>Sara 1 15 Eiro</SPAN></P><P><SPAN>Sara 3 10 Eiro</SPAN></P><P> </P><P> </P><P><SPAN>And I have TABLE_2 with exact sales data:</SPAN></P><P><SPAN>Client Sold</SPAN></P><P><SPAN>John 1</SPAN></P><P><SPAN>Sara 4</SPAN></P><P> </P><P><SPAN>I need to compare these two table in order to calculate correct price based on the following logic:</SPAN></P><P><SPAN> IF John bought at least 5 Kg, his price would be 5 Eiro, </SPAN></P><P><SPAN>Then IF John bought at least 2 Kg, his price would be 10 Eiro, </SPAN></P><P><SPAN>Then IF John bought at least 1 Kg, his price would be 20 Eiro, </SPAN></P><P><SPAN>else ... (can make Null() value right now, but in fact have to be 20 Eiro)</SPAN></P><P><SPAN> </SPAN></P><P><SPAN>According to this logic, the result have to be like in Table_3:</SPAN></P><P><SPAN>Client Correct Price</SPAN></P><P><SPAN>John 20 Eiro</SPAN></P><P><SPAN>Sara 10 Eiro</SPAN></P><P> </P><P> </P><P><SPAN>I need to understan, how to calculate Table 3</SPAN></P><P> </P><P> </P><P> </P>Wed, 25 Nov 2020 16:16:04 GMTsculptorlv2020-11-25T16:16:04ZPlease help with intervals
https://community.qlik.com/t5/QlikView-App-Dev/Please-help-with-intervals/m-p/1531443#M748203
<P>Good day!</P><P>I am looking for the solution.</P><P> </P><P>I have a table like TABLE_1 with sales contract parameters:</P><P>Client Min_Quantity Price</P><P>John 1 20 Eiro</P><P><SPAN>John 2 10 Eiro</SPAN></P><P><SPAN>John 5 5 Eiro</SPAN></P><P><SPAN>Sara 1 15 Eiro</SPAN></P><P><SPAN>Sara 3 10 Eiro</SPAN></P><P> </P><P> </P><P><SPAN>And I have TABLE_2 with exact sales data:</SPAN></P><P><SPAN>Client Sold</SPAN></P><P><SPAN>John 1</SPAN></P><P><SPAN>Sara 4</SPAN></P><P> </P><P><SPAN>I need to compare these two table in order to calculate correct price based on the following logic:</SPAN></P><P><SPAN> IF John bought at least 5 Kg, his price would be 5 Eiro, </SPAN></P><P><SPAN>Then IF John bought at least 2 Kg, his price would be 10 Eiro, </SPAN></P><P><SPAN>Then IF John bought at least 1 Kg, his price would be 20 Eiro, </SPAN></P><P><SPAN>else ... (can make Null() value right now, but in fact have to be 20 Eiro)</SPAN></P><P><SPAN> </SPAN></P><P><SPAN>According to this logic, the result have to be like in Table_3:</SPAN></P><P><SPAN>Client Correct Price</SPAN></P><P><SPAN>John 20 Eiro</SPAN></P><P><SPAN>Sara 10 Eiro</SPAN></P><P> </P><P> </P><P><SPAN>I need to understan, how to calculate Table 3</SPAN></P><P> </P><P> </P><P> </P>Wed, 25 Nov 2020 16:16:04 GMThttps://community.qlik.com/t5/QlikView-App-Dev/Please-help-with-intervals/m-p/1531443#M748203sculptorlv2020-11-25T16:16:04Z