topic calculated dimension from another chart in QlikView https://community.qlik.com/t5/QlikView/calculated-dimension-from-another-chart/m-p/245859#M93685 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I got a pivot table with 2 dimensions(ItemID, Date) and 2 expressions (E1, and E2)</P><P>this pivot table shows a sample data the following</P><P></P><P>ItemID&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E2</P><P>27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28/8/2007&nbsp;&nbsp;&nbsp;&nbsp; 4500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29/8/2007&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P>34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28/8/2007&nbsp;&nbsp;&nbsp;&nbsp; 3450&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29/8/2008&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P>...</P><P></P><P>now what I want is a clone of this above pivot table but only showing the rows with non null expression values</P><P>knowing that the expression E1 is very complex and I forced it to show NULL() if a certain condition was satisfied</P></BODY></HTML> Thu, 08 Sep 2011 07:25:12 GMT ali_hijazi 2011-09-08T07:25:12Z calculated dimension from another chart https://community.qlik.com/t5/QlikView/calculated-dimension-from-another-chart/m-p/245859#M93685 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I got a pivot table with 2 dimensions(ItemID, Date) and 2 expressions (E1, and E2)</P><P>this pivot table shows a sample data the following</P><P></P><P>ItemID&nbsp;&nbsp;&nbsp;&nbsp; Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; E2</P><P>27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28/8/2007&nbsp;&nbsp;&nbsp;&nbsp; 4500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>27&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29/8/2007&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P>34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 28/8/2007&nbsp;&nbsp;&nbsp;&nbsp; 3450&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>34&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 29/8/2008&nbsp;&nbsp;&nbsp;&nbsp; -&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -</P><P>...</P><P></P><P>now what I want is a clone of this above pivot table but only showing the rows with non null expression values</P><P>knowing that the expression E1 is very complex and I forced it to show NULL() if a certain condition was satisfied</P></BODY></HTML> Thu, 08 Sep 2011 07:25:12 GMT https://community.qlik.com/t5/QlikView/calculated-dimension-from-another-chart/m-p/245859#M93685 ali_hijazi 2011-09-08T07:25:12Z