topic Re: Expression based on condition in QlikView https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012432#M465117 <HTML><HEAD></HEAD><BODY><P>And please don't create multiple threads for the same topic, it's really hard to follow a discussion.</P><P></P><P>Seems you got a similar answers in both threads anyway <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plain.png" /></P></BODY></HTML> Wed, 30 Mar 2016 13:18:40 GMT swuehl 2016-03-30T13:18:40Z Expression based on condition https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012428#M465113 <HTML><HEAD></HEAD><BODY><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>dim1</STRONG></TH><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>price</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG style="color: #ffffff; font-size: 13.3333px; text-align: center;">amount</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">total</TH></TR><TR><TD style="padding: 2px;">xxx</TD><TD style="padding: 2px;">A</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">xxx</TD><TD style="padding: 2px;">B</TD><TD style="padding: 2px;">6</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">6</TD></TR><TR><TD style="padding: 2px;">xxx</TD><TD style="padding: 2px;">C</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">3</TD><TD style="padding: 2px;">9</TD></TR></TBODY></TABLE><P></P><P>I want to hide <EM>price</EM> and <EM>amount</EM> from product B and only show totals for the products A en C, i cant figure this out in Qlikview. <BR />any suggestions?</P><P></P><P></P><P></P><P>Im using a pivot table with three expressions:</P><P></P><P>Amount:</P><P>(sum(amount)/count(DISTINCT Month))</P><P></P><P>Price:</P><P>(sum(total))/</P><P>(sum(amount)/count(DISTINCT Month))</P><P></P><P>total:</P><P>sum(total)</P></BODY></HTML> Wed, 30 Mar 2016 09:42:15 GMT https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012428#M465113 2016-03-30T09:42:15Z Re: Expression based on condition https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012429#M465114 <HTML><HEAD></HEAD><BODY><P>may be this</P><P><IMG alt="hide.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119861_hide.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 30 Mar 2016 11:27:46 GMT https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012429#M465114 Chanty4u 2016-03-30T11:27:46Z Re: Expression based on condition https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012430#M465115 <HTML><HEAD></HEAD><BODY><P>Like I mentioned here (<A href="https://community.qlik.com/thread/211391">condition based expression</A>), would you be able to share a sample?</P></BODY></HTML> Wed, 30 Mar 2016 11:31:01 GMT https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012430#M465115 sunny_talwar 2016-03-30T11:31:01Z Re: Expression based on condition https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012431#M465116 <HTML><HEAD></HEAD><BODY><P>do u like this?</P><P><IMG alt="match.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119859_match.PNG" style="height: 236px; width: 620px;" /></P></BODY></HTML> Wed, 30 Mar 2016 11:41:17 GMT https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012431#M465116 buzzy996 2016-03-30T11:41:17Z Re: Expression based on condition https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012432#M465117 <HTML><HEAD></HEAD><BODY><P>And please don't create multiple threads for the same topic, it's really hard to follow a discussion.</P><P></P><P>Seems you got a similar answers in both threads anyway <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plain.png" /></P></BODY></HTML> Wed, 30 Mar 2016 13:18:40 GMT https://community.qlik.com/t5/QlikView/Expression-based-on-condition/m-p/1012432#M465117 swuehl 2016-03-30T13:18:40Z