https://community.qlik.com/t5/QlikView/collapse-a-calculated-dimension/m-p/201997#M59857 <HTML><HEAD></HEAD><BODY><P>Just thought I should mention I'm doing this in QV 8.5, looks like it works fine in 9. Dissapointing, I guess I'll have to find some other way.</P></BODY></HTML> Wed, 15 Sep 2010 12:20:35 GMT richnorris 2010-09-15T12:20:35Z https://community.qlik.com/t5/QlikView/collapse-a-calculated-dimension/m-p/201996#M59856 <HTML><HEAD></HEAD><BODY><P>I've got a pivot table showing Sales Client, Sales Client Country and Sales client type. The Sales Client is a calculated dimension, so that it is only showing the top 100 clients. The reason I have it as a pivot is so that I can collapse everything down to only show the Client, such that each client has just one row, and the chart is able to show the volume for each client, but with the ability to drill down to country or type level.</P><P>However, I cant seem to find a way to collapse country and type down, I just cant seem to get the square + / - box for Sales Client. Is this because it is a calculated dimension? Is there another way of limiting Sales clients to those with the top 100 volume?</P><P>Thanks</P></BODY></HTML> Wed, 15 Sep 2010 11:55:52 GMT https://community.qlik.com/t5/QlikView/collapse-a-calculated-dimension/m-p/201996#M59856 richnorris 2010-09-15T11:55:52Z https://community.qlik.com/t5/QlikView/collapse-a-calculated-dimension/m-p/201997#M59857 <HTML><HEAD></HEAD><BODY><P>Just thought I should mention I'm doing this in QV 8.5, looks like it works fine in 9. Dissapointing, I guess I'll have to find some other way.</P></BODY></HTML> Wed, 15 Sep 2010 12:20:35 GMT https://community.qlik.com/t5/QlikView/collapse-a-calculated-dimension/m-p/201997#M59857 richnorris 2010-09-15T12:20:35Z https://community.qlik.com/t5/QlikView/collapse-a-calculated-dimension/m-p/201998#M59858 <HTML><HEAD></HEAD><BODY><P>I dont really understand whats going on here, is there a way to specify which dimensions get collapsed and which dont that I'm missing? My other calculated dimension collapses fine?</P></BODY></HTML> Wed, 15 Sep 2010 14:01:08 GMT https://community.qlik.com/t5/QlikView/collapse-a-calculated-dimension/m-p/201998#M59858 richnorris 2010-09-15T14:01:08Z