topic Re: Calculated dimension with Set analysis? in QlikView https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661510#M474770 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to show all the transactions regardless of the field key shop &amp; date.</P><P>This key is linked to a selection in the sheet, and I would like to ignore it in the table I described above.</P><P></P><P>thanks!</P><P></P><P><IMG alt="img.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65366_img.png" style="width: 620px; height: 86px;" /></P></BODY></HTML> Wed, 27 Aug 2014 13:01:22 GMT dafnis14 2014-08-27T13:01:22Z Calculated dimension with Set analysis? https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661508#M474768 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a table with different types of transactions of a financial document.</P><P>Each transaction has a key with the date of the <SPAN style="text-decoration: underline;">first</SPAN> transaction and the document ID.</P><P>So when the user selects a certain date, all the transactions are linked by that key.</P><P>But, I would like to create a table where this key is ignored, and all the transactions are displayed according to their transaction dates. The&nbsp; dimension is the document number.</P><P>My question is, how to create the calculated dimension, and&nbsp; ignore the key in that table. </P><P></P><P>&nbsp; <SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';">Thanks!</SPAN></P></BODY></HTML> Wed, 27 Aug 2014 11:49:22 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661508#M474768 dafnis14 2014-08-27T11:49:22Z Re: Calculated dimension with Set analysis? https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661509#M474769 <HTML><HEAD></HEAD><BODY><P>Kindly Provide Sample Data.... !</P></BODY></HTML> Wed, 27 Aug 2014 11:50:08 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661509#M474769 MK_QSL 2014-08-27T11:50:08Z Re: Calculated dimension with Set analysis? https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661510#M474770 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to show all the transactions regardless of the field key shop &amp; date.</P><P>This key is linked to a selection in the sheet, and I would like to ignore it in the table I described above.</P><P></P><P>thanks!</P><P></P><P><IMG alt="img.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/65366_img.png" style="width: 620px; height: 86px;" /></P></BODY></HTML> Wed, 27 Aug 2014 13:01:22 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661510#M474770 dafnis14 2014-08-27T13:01:22Z Re: Calculated dimension with Set analysis? https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661511#M474771 <HTML><HEAD></HEAD><BODY><P>Need base data in excel file to work... </P></BODY></HTML> Wed, 27 Aug 2014 13:02:11 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661511#M474771 MK_QSL 2014-08-27T13:02:11Z Re: Calculated dimension with Set analysis? https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661512#M474772 <HTML><HEAD></HEAD><BODY><P>Use nested iff.</P><P>I dont think it will work </P></BODY></HTML> Wed, 27 Aug 2014 13:02:26 GMT https://community.qlik.com/t5/QlikView/Calculated-dimension-with-Set-analysis/m-p/661512#M474772 sujeetsingh 2014-08-27T13:02:26Z