topic Re: Daten filtern in Pivottabellen in QlikView https://community.qlik.com/t5/QlikView/Daten-filtern-in-Pivottabellen/m-p/501052#M187240 <HTML><HEAD></HEAD><BODY><P>try&nbsp; this&nbsp; dimension side</P><P>aggr(if(Rang&gt;2,Rang),Rang)</P><P>and in expression used other fields</P><P>if you want other fields on the basis of this like <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Artikel&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">then </SPAN></P><P>aggr(if(Rang&gt;2,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Artikel</SPAN>),Rang)</P><P>in label side write this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Artikel</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">hope it helps<BR /></SPAN></P></BODY></HTML> Tue, 10 Sep 2013 06:52:46 GMT er_mohit 2013-09-10T06:52:46Z Daten filtern in Pivottabellen https://community.qlik.com/t5/QlikView/Daten-filtern-in-Pivottabellen/m-p/501051#M187239 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />in meinem Datenmodell verwende ich die Tabellen "Artikel" und "Preisliste". Die Verbindung folgt über die Artikelnummer, zu einem Artikel kann es n Preislisteneinträge geben mit unterschiedlichem Gültigkeitszeitraum.<BR />Artikel&nbsp;&nbsp; Gültig ab&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Preis&nbsp;&nbsp;&nbsp;&nbsp; Rang<BR />4711&nbsp;&nbsp;&nbsp;&nbsp; 01.01.2013&nbsp;&nbsp;&nbsp; 122€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1<BR />4711&nbsp;&nbsp;&nbsp;&nbsp; 01.01.2012&nbsp;&nbsp;&nbsp;&nbsp; 115€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2<BR />4711&nbsp;&nbsp;&nbsp;&nbsp; 01.01.2011&nbsp;&nbsp;&nbsp;&nbsp; 109€&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3<BR />....</P><P>Ich möchte in der Pivottabelle nur die letzten zwei&nbsp; Preise pro Artikel anzeigen. Wie kann ich alles was RANG &gt; 2 hat ausblenden bzw. wegfiltern?<BR />Danke vorab für die Hilfe<BR />Wolfgang </P></BODY></HTML> Tue, 10 Sep 2013 06:31:43 GMT https://community.qlik.com/t5/QlikView/Daten-filtern-in-Pivottabellen/m-p/501051#M187239 2013-09-10T06:31:43Z Re: Daten filtern in Pivottabellen https://community.qlik.com/t5/QlikView/Daten-filtern-in-Pivottabellen/m-p/501052#M187240 <HTML><HEAD></HEAD><BODY><P>try&nbsp; this&nbsp; dimension side</P><P>aggr(if(Rang&gt;2,Rang),Rang)</P><P>and in expression used other fields</P><P>if you want other fields on the basis of this like <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Artikel&nbsp;&nbsp; </SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">then </SPAN></P><P>aggr(if(Rang&gt;2,<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Artikel</SPAN>),Rang)</P><P>in label side write this</P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Artikel</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">hope it helps<BR /></SPAN></P></BODY></HTML> Tue, 10 Sep 2013 06:52:46 GMT https://community.qlik.com/t5/QlikView/Daten-filtern-in-Pivottabellen/m-p/501052#M187240 er_mohit 2013-09-10T06:52:46Z Re: Daten filtern in Pivottabellen https://community.qlik.com/t5/QlikView/Daten-filtern-in-Pivottabellen/m-p/501053#M187241 <HTML><HEAD></HEAD><BODY><P>hello mohit (and everybody else), </P><P>thanks for your answer. im total new with qlikview, so i could not really understand your solution. </P><P>i restate my question one more time in english.</P><P></P><P>im using the tables "produkt" and "pricelist". one record of the table "Produkt " has n records in the table "pricelist". </P><P></P><P></P><P>this ist the data shown in a pivot-table.</P><P></P><P>Produkt Price effective from Price Ranking</P><P>4711 01.01.2013 122€ 1</P><P>4711 01.01.2012 115€ 2</P><P>4711 01.01.2011 109€ 3</P><P>4711 01.01.2010 105€ 4</P><P>4712 01.01.2013 164€ 1</P><P>4712 01.01.2012 162€ 2</P><P>4712 01.01.2011 157€ 3</P><P>4712 01.01.2010 151€ 4</P><P></P><P>....</P><P></P><P>The Column "Ranking" is created by the following statement </P><P>Rank(V_PRLP.PRLD_DTVON) </P><P></P><P>and now the challenge. i want to supress all lines in the Pivot-table where the Ranking is &gt; 2</P><P></P><P>this is the data that shoud be shown in the table after supressing the lines</P><P></P><P>Produkt Price effective from Price Ranking</P><P>4711 01.01.2013 122€ 1</P><P>4711 01.01.2012 115€ 2</P><P>4712 01.01.2013 164€ 1</P><P>4712 01.01.2012 162€ 2</P><P></P><P>i hope i could explain my problem now and maybe you can help me one more time?</P><P></P><P>thank you very mutch</P><P></P><P>wolfgang</P></BODY></HTML> Tue, 10 Sep 2013 13:53:35 GMT https://community.qlik.com/t5/QlikView/Daten-filtern-in-Pivottabellen/m-p/501053#M187241 2013-09-10T13:53:35Z Re: Re: Daten filtern in Pivottabellen https://community.qlik.com/t5/QlikView/Daten-filtern-in-Pivottabellen/m-p/501054#M187242 <HTML><HEAD></HEAD><BODY><P>Hallo Wolfgang,</P><P></P><P>you can define the ranking in the script. Then is is easier to filter in the pivot table</P><P></P><P>find attached exemple</P><P></P><P>regards</P><P>Bumin</P></BODY></HTML> Sun, 19 Jan 2014 15:14:47 GMT https://community.qlik.com/t5/QlikView/Daten-filtern-in-Pivottabellen/m-p/501054#M187242 bumin 2014-01-19T15:14:47Z