topic Comparing scenarios in QlikView https://community.qlik.com/t5/QlikView/Comparing-scenarios/m-p/193816#M54940 <HTML><HEAD></HEAD><BODY><P style="margin: 0in 0in 10pt;">Hi guys...</P><P style="margin: 0in 0in 10pt;">I have a challenge. I have two fields, ResponsiveCatCode and ResponsiveCategories. I want formula for certain scenarios.</P><P style="margin: 0in 0in 10pt;">If ResponsiveCatCode = ResponsiveCategories, it should not show Error AND ResponsiveCatCode not equal to ResponsiveCategories, it should give 'Error1' AND if ResponsiveCategories is blank, it should give 'Error2'.</P><P style="margin: 0in 0in 10pt;">I tried with the below formula,</P><P style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;">=If(ResponCatCode&lt;&gt;ResponsiveCategories, 'Error1' &amp; If(ResponCatCode=ResponCatCode &amp; IsNull(ResponsiveCategories), 'Error2'))</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">but it dint work..</P><P style="margin: 0in 0in 10pt;">Please help me…</P></BODY></HTML> Thu, 25 Mar 2010 14:34:15 GMT renjithpl 2010-03-25T14:34:15Z Comparing scenarios https://community.qlik.com/t5/QlikView/Comparing-scenarios/m-p/193816#M54940 <HTML><HEAD></HEAD><BODY><P style="margin: 0in 0in 10pt;">Hi guys...</P><P style="margin: 0in 0in 10pt;">I have a challenge. I have two fields, ResponsiveCatCode and ResponsiveCategories. I want formula for certain scenarios.</P><P style="margin: 0in 0in 10pt;">If ResponsiveCatCode = ResponsiveCategories, it should not show Error AND ResponsiveCatCode not equal to ResponsiveCategories, it should give 'Error1' AND if ResponsiveCategories is blank, it should give 'Error2'.</P><P style="margin: 0in 0in 10pt;">I tried with the below formula,</P><P style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;">=If(ResponCatCode&lt;&gt;ResponsiveCategories, 'Error1' &amp; If(ResponCatCode=ResponCatCode &amp; IsNull(ResponsiveCategories), 'Error2'))</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">but it dint work..</P><P style="margin: 0in 0in 10pt;">Please help me…</P></BODY></HTML> Thu, 25 Mar 2010 14:34:15 GMT https://community.qlik.com/t5/QlikView/Comparing-scenarios/m-p/193816#M54940 renjithpl 2010-03-25T14:34:15Z Comparing scenarios https://community.qlik.com/t5/QlikView/Comparing-scenarios/m-p/193817#M54941 <HTML><HEAD></HEAD><BODY><P>Try something like this (2 If statements encapsulated):</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />=If(ResponCatCode&lt;&gt;ResponsiveCategories, 'Error1',If(ResponCatCode=ResponCatCode &amp; IsNull(ResponsiveCategories), 'Error2')))<BR /></PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Thu, 25 Mar 2010 14:40:47 GMT https://community.qlik.com/t5/QlikView/Comparing-scenarios/m-p/193817#M54941 2010-03-25T14:40:47Z Comparing scenarios https://community.qlik.com/t5/QlikView/Comparing-scenarios/m-p/193818#M54942 <HTML><HEAD></HEAD><BODY><P>Think you already where on the right path with the solution ... but only the if should be build up differently ...</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />If(ResponCatCode&lt;&gt;ResponsiveCategories, 'Error1',<BR /> If(ResponCatCode=ResponCatCode and IsNull(ResponsiveCategories), 'Error2'))<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P></P><P></P><P>Anita</P></BODY></HTML> Thu, 25 Mar 2010 14:41:22 GMT https://community.qlik.com/t5/QlikView/Comparing-scenarios/m-p/193818#M54942 Anonymous 2010-03-25T14:41:22Z