topic Re: Display records in Water Cooler https://community.qlik.com/t5/Water-Cooler/Display-records/m-p/610243#M2652 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Thanks a lot for the information</P><P></P><P>Marc</P></BODY></HTML> Sun, 23 Mar 2014 08:40:07 GMT 2014-03-23T08:40:07Z Display records https://community.qlik.com/t5/Water-Cooler/Display-records/m-p/610241#M2650 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>In a pivot table,&nbsp; I only want to display the records where for each item in the field “Besteknummer”<BR />there are the items “Goedkeuring bestek” and “Gunning van de opdracht” in the field “Etappe tekst”.</P><P>How can I achieve that ?</P><P>Thanks in advance<BR />Marc</P></BODY></HTML> Sun, 23 Mar 2014 07:40:29 GMT https://community.qlik.com/t5/Water-Cooler/Display-records/m-p/610241#M2650 2014-03-23T07:40:29Z Re: Display records https://community.qlik.com/t5/Water-Cooler/Display-records/m-p/610242#M2651 <HTML><HEAD></HEAD><BODY><P>A chart like a pivot table is used to aggregate records grouped by dimensions. So if you want to display records, you'll need to add a dimension that is unique on the lowest level you want to see, i.e. record level. So you probably need to add something like a RecId to your data model and your chart dimensions. Then you can filter your records using conditionals or adding a set expressionset in the aggregation function.</P></BODY></HTML> Sun, 23 Mar 2014 08:14:38 GMT https://community.qlik.com/t5/Water-Cooler/Display-records/m-p/610242#M2651 swuehl 2014-03-23T08:14:38Z Re: Display records https://community.qlik.com/t5/Water-Cooler/Display-records/m-p/610243#M2652 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Thanks a lot for the information</P><P></P><P>Marc</P></BODY></HTML> Sun, 23 Mar 2014 08:40:07 GMT https://community.qlik.com/t5/Water-Cooler/Display-records/m-p/610243#M2652 2014-03-23T08:40:07Z