topic Requirement in QlikView https://community.qlik.com/t5/QlikView/Requirement/m-p/33985#M5757 <HTML><HEAD></HEAD><BODY><P>i have two alternate states defined in my sheet,state 1 and state2</P><P>state1 in chart shud show the selected dimension (whatever is from filter)</P><P>and state 2 expressions shud show everything excluding the state1 expressions,</P><P>so say:</P><P>count({state1 * $}id)</P><P></P><P>how shud the state 2 expressions wud be written?</P></BODY></HTML> Thu, 31 May 2018 06:19:04 GMT Anonymous 2018-05-31T06:19:04Z Requirement https://community.qlik.com/t5/QlikView/Requirement/m-p/33985#M5757 <HTML><HEAD></HEAD><BODY><P>i have two alternate states defined in my sheet,state 1 and state2</P><P>state1 in chart shud show the selected dimension (whatever is from filter)</P><P>and state 2 expressions shud show everything excluding the state1 expressions,</P><P>so say:</P><P>count({state1 * $}id)</P><P></P><P>how shud the state 2 expressions wud be written?</P></BODY></HTML> Thu, 31 May 2018 06:19:04 GMT https://community.qlik.com/t5/QlikView/Requirement/m-p/33985#M5757 Anonymous 2018-05-31T06:19:04Z Re: Requirement https://community.qlik.com/t5/QlikView/Requirement/m-p/33986#M5758 <HTML><HEAD></HEAD><BODY><P>can anyone please help for the above query</P></BODY></HTML> Thu, 31 May 2018 07:25:18 GMT https://community.qlik.com/t5/QlikView/Requirement/m-p/33986#M5758 Anonymous 2018-05-31T07:25:18Z Re: Requirement https://community.qlik.com/t5/QlikView/Requirement/m-p/33987#M5759 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">try this: count( { 1 - (state1*$) } id )</SPAN></P></BODY></HTML> Thu, 31 May 2018 07:50:28 GMT https://community.qlik.com/t5/QlikView/Requirement/m-p/33987#M5759 Gysbert_Wassenaar 2018-05-31T07:50:28Z Re: Requirement https://community.qlik.com/t5/QlikView/Requirement/m-p/33988#M5760 <HTML><HEAD></HEAD><BODY><P>so if there are no selections made its just showing me state 1 bar,</P><P>what will be the state 2 den?</P></BODY></HTML> Thu, 31 May 2018 08:20:59 GMT https://community.qlik.com/t5/QlikView/Requirement/m-p/33988#M5760 Anonymous 2018-05-31T08:20:59Z Re: Requirement https://community.qlik.com/t5/QlikView/Requirement/m-p/33989#M5761 <HTML><HEAD></HEAD><BODY><P>empty</P></BODY></HTML> Thu, 31 May 2018 08:23:00 GMT https://community.qlik.com/t5/QlikView/Requirement/m-p/33989#M5761 Gysbert_Wassenaar 2018-05-31T08:23:00Z