topic Re: Behaviour of Calculated Dimension in QlikView https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710430#M1060320 <HTML><HEAD></HEAD><BODY><P>Hi, check the actual selection box, you dont have any other selection? none of the selection remove?</P><P></P><P>put an image or attach the qvd as an example</P></BODY></HTML> Sun, 28 Sep 2014 13:01:09 GMT fkeuroglian 2014-09-28T13:01:09Z Behaviour of Calculated Dimension https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710428#M1060318 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have created a new calculated dimension using 2 dimension in if statement. For example</P><P>=IF(TRIP = 12345 AND CURRENCY = 'USD','US','IN'). I used the straight table chart and 2 rows appeared on the chart. I clicked on US on the chart and it filtered for the US row but when I clicked the US again the filter was not removed and the only way I could remove the filter was to use the clear button. Is this a normal behavior or do anyone of you have answer on how to make this work.</P></BODY></HTML> Sun, 28 Sep 2014 10:24:28 GMT https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710428#M1060318 2014-09-28T10:24:28Z Re: Behaviour of Calculated Dimension https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710429#M1060319 <HTML><HEAD></HEAD><BODY><P>Filter should be removed when you clicked field again. Can you provide sample qvw</P></BODY></HTML> Sun, 28 Sep 2014 12:02:50 GMT https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710429#M1060319 anbu1984 2014-09-28T12:02:50Z Re: Behaviour of Calculated Dimension https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710430#M1060320 <HTML><HEAD></HEAD><BODY><P>Hi, check the actual selection box, you dont have any other selection? none of the selection remove?</P><P></P><P>put an image or attach the qvd as an example</P></BODY></HTML> Sun, 28 Sep 2014 13:01:09 GMT https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710430#M1060320 fkeuroglian 2014-09-28T13:01:09Z Re: Re: Behaviour of Calculated Dimension https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710431#M1060321 <HTML><HEAD></HEAD><BODY><P>Anbu,</P><P>Please check the attached Qvw. It has 2 rows but when you click on US it will filter to one row but when you Click US again the filter does not get removed. </P></BODY></HTML> Sun, 28 Sep 2014 13:58:44 GMT https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710431#M1060321 2014-09-28T13:58:44Z Re: Re: Behaviour of Calculated Dimension https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710432#M1060322 <HTML><HEAD></HEAD><BODY><P>Hi Fernando,</P><P></P><P>I have attached the QVW in reply to Anbu as you can see the behavior of what I explained.</P></BODY></HTML> Sun, 28 Sep 2014 13:59:27 GMT https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710432#M1060322 2014-09-28T13:59:27Z Re: Re: Re: Behaviour of Calculated Dimension https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710433#M1060323 <HTML><HEAD></HEAD><BODY><P>Hi, see the attached.</P><P></P><P>it is not a bad behaviour, if you create the dimension calculated will be behave of that way.</P><P></P><P>always, if you have the possibility , i recommend creating the calculated dimension (flag using "if") in the script, and the in the object you only have to call them and put as a dimension.</P><P></P><P>see the attach example, and test now, i think that is the correct use</P><P></P><P>good luck</P><P></P><P>Fernando</P></BODY></HTML> Sun, 28 Sep 2014 14:18:29 GMT https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710433#M1060323 fkeuroglian 2014-09-28T14:18:29Z Re: Behaviour of Calculated Dimension https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710434#M1060324 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>you could try a listbox with calculated dimension an expression instead:</P><P></P><P><IMG alt="QlikCommunity_Thread_135266_Pic1.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/67821_QlikCommunity_Thread_135266_Pic1.JPG.jpg" /></P><P></P><P></P><P></P><P><IMG alt="QlikCommunity_Thread_135266_Pic2.JPG.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/67822_QlikCommunity_Thread_135266_Pic2.JPG.jpg" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Sun, 28 Sep 2014 15:51:52 GMT https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710434#M1060324 MarcoWedel 2014-09-28T15:51:52Z Re: Behaviour of Calculated Dimension https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710435#M1060325 <HTML><HEAD></HEAD><BODY><P>good</P></BODY></HTML> Thu, 30 Oct 2014 07:18:41 GMT https://community.qlik.com/t5/QlikView/Behaviour-of-Calculated-Dimension/m-p/710435#M1060325 sakamsureshbabu 2014-10-30T07:18:41Z