topic Re: A simple problem, or not ? in QlikView https://community.qlik.com/t5/QlikView/A-simple-problem-or-not/m-p/842016#M295926 <HTML><HEAD></HEAD><BODY><P>Definitely not simple. You want to use associative logic based on manually entered values that change in each successive row. </P><P>A complex problem can still have a simple solution, as with almost everything QlikView...</P></BODY></HTML> Thu, 02 Apr 2015 07:28:25 GMT Peter_Cammaert 2015-04-02T07:28:25Z A simple problem, or not ? https://community.qlik.com/t5/QlikView/A-simple-problem-or-not/m-p/842015#M295925 <HTML><HEAD></HEAD><BODY><P>Hello to the community,</P><P>I row for a while, and unsuccessfully, to find a solution to the problem below:</P><P>Imagine a table with:</P><P>* In column 1, list my products</P><P>* In column 2, the level of distribution of a product (value = T1, T2, T3, for example)</P><P>* In column 3, a number corresponding to the value of column 2 (supplied via a table specifying T1 = 100, T2 =70 and T3 = 30).</P><P></P><P>Until then, it is very simple.</P><P></P><P>What I want is in the same table add 2 columns:</P><P>* Column 4: equals default in column 2, but this my be modified, by the user either by writing (T2 for example) or drop-down list (display T1, T2 or T3)</P><P>* Column 5: depending on the choice made in column 4, I display the corresponding value (eg, if the user selected T2 in column 4, displaying the value 70).</P><P></P><P>An example in this table:</P><P></P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Product</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Distrib actually</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Ditrib value actually</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; font-size: 13.3333330154419px; text-align: center;">Distrib wished</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; font-size: 13.3333330154419px; text-align: center;">Ditrib value wished</STRONG></TH></TR><TR><TD style="padding: 2px;">Product 1</TD><TD style="padding: 2px;">T1</TD><TD style="padding: 2px;">100</TD><TD style="padding: 2px;">T2</TD><TD style="padding: 2px;">70</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333330154419px;">Product 2</SPAN></TD><TD style="padding: 2px;">T2</TD><TD style="padding: 2px;">70</TD><TD style="padding: 2px;">T1</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P>Thank you for your help, that would make me a HUGE Service:-)</P></BODY></HTML> Thu, 02 Apr 2015 07:04:52 GMT https://community.qlik.com/t5/QlikView/A-simple-problem-or-not/m-p/842015#M295925 2015-04-02T07:04:52Z Re: A simple problem, or not ? https://community.qlik.com/t5/QlikView/A-simple-problem-or-not/m-p/842016#M295926 <HTML><HEAD></HEAD><BODY><P>Definitely not simple. You want to use associative logic based on manually entered values that change in each successive row. </P><P>A complex problem can still have a simple solution, as with almost everything QlikView...</P></BODY></HTML> Thu, 02 Apr 2015 07:28:25 GMT https://community.qlik.com/t5/QlikView/A-simple-problem-or-not/m-p/842016#M295926 Peter_Cammaert 2015-04-02T07:28:25Z Re: A simple problem, or not ? https://community.qlik.com/t5/QlikView/A-simple-problem-or-not/m-p/842017#M295927 <HTML><HEAD></HEAD><BODY><P>I hope so ... !!! <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Thu, 02 Apr 2015 08:16:22 GMT https://community.qlik.com/t5/QlikView/A-simple-problem-or-not/m-p/842017#M295927 2015-04-02T08:16:22Z