topic unique records and performance with combined fields in QlikView https://community.qlik.com/t5/QlikView/unique-records-and-performance-with-combined-fields/m-p/259671#M98027 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Just wondering, I am trying to create a performant application for a 600 mln record dataset. We already reduced the number of columns, but now I want to speed up QV by reducing the number of unique records within a field. Problem is that the end user would like to see combined fields like 01/DDFFGG where I want to split 01 and DDFFGG. How would you solve this? </P><P></P><OL><LI>a variable in the front which combines them so you don't have the unique values in the database</LI><LI>other options?</LI></OL><P></P><P>thank you very much</P></BODY></HTML> Mon, 28 Nov 2011 12:39:53 GMT 2011-11-28T12:39:53Z unique records and performance with combined fields https://community.qlik.com/t5/QlikView/unique-records-and-performance-with-combined-fields/m-p/259671#M98027 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>Just wondering, I am trying to create a performant application for a 600 mln record dataset. We already reduced the number of columns, but now I want to speed up QV by reducing the number of unique records within a field. Problem is that the end user would like to see combined fields like 01/DDFFGG where I want to split 01 and DDFFGG. How would you solve this? </P><P></P><OL><LI>a variable in the front which combines them so you don't have the unique values in the database</LI><LI>other options?</LI></OL><P></P><P>thank you very much</P></BODY></HTML> Mon, 28 Nov 2011 12:39:53 GMT https://community.qlik.com/t5/QlikView/unique-records-and-performance-with-combined-fields/m-p/259671#M98027 2011-11-28T12:39:53Z