topic AW:how to check dimension is expand /collapse in QlikView https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185217#M589373 <HTML><HEAD></HEAD><BODY><P>Nobody?</P><P>Maybe some Macrofunction? I didn't find anything in the API-"doc".</P><P>Pls help <IMG alt="Tongue Tied" src="http://community.qlik.com/emoticons/emotion-7.gif" /></P><P></P><P>Greetings</P></BODY></HTML> Tue, 15 Sep 2009 21:25:13 GMT 2009-09-15T21:25:13Z how to check dimension is expand /collapse https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185216#M589372 <HTML><HEAD></HEAD><BODY><P>i need to vary a variable on the 'Expanded / Collapsed Status' of the (first, second and third) Dimensions in my Pivot-Table.</P><P>prop.TableProperties.PivotAlwaysFullyExpanded is no help because i need to verify the separate status of any Dimension .</P><P>Is there any Method / any way to determine if an specific Dimension is expanded or collapsed?</P><P>Any idea?</P><P></P><P></P><P>Sorry for the bad English. I'm out of practice .</P><P>Greetings from Berlin</P><P></P></BODY></HTML> Mon, 14 Sep 2009 15:53:49 GMT https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185216#M589372 2009-09-14T15:53:49Z AW:how to check dimension is expand /collapse https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185217#M589373 <HTML><HEAD></HEAD><BODY><P>Nobody?</P><P>Maybe some Macrofunction? I didn't find anything in the API-"doc".</P><P>Pls help <IMG alt="Tongue Tied" src="http://community.qlik.com/emoticons/emotion-7.gif" /></P><P></P><P>Greetings</P></BODY></HTML> Tue, 15 Sep 2009 21:25:13 GMT https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185217#M589373 2009-09-15T21:25:13Z AW:how to check dimension is expand /collapse https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185218#M589374 <HTML><HEAD></HEAD><BODY><P>i still need help!</P></BODY></HTML> Wed, 16 Sep 2009 23:26:29 GMT https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185218#M589374 2009-09-16T23:26:29Z how to check dimension is expand /collapse https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185219#M589375 <HTML><HEAD></HEAD><BODY><P>I don't think there is anything in the API that will help you. There isn't a property (or event) for expanded/collapsed.</P><P>If you're looking to do something within the chart, you could use the Dimensionality() function. If you add Dimensionality() as an expression in your chart, it should equal one when your dimensions are all collapsed. When you open the first one, it should go to 2 and so on. This would allow you to vary the expression depending on the expanded/collapsed state of that record.</P><P>I don't think there is way to access this information outside of the chart. Maybe if you could describe what you're trying to do in more detail, somebody could come up with something.</P></BODY></HTML> Wed, 16 Sep 2009 23:55:57 GMT https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185219#M589375 2009-09-16T23:55:57Z AW:Re: how to check dimension is expand /collapse https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185220#M589376 <HTML><HEAD></HEAD><BODY><P>i think i found a solution:</P><P><BR /> set chart = ActiveDocument.GetSheetObject("CH468")<BR /> set Prop = chart.GetProperties</P><P>iexpr=Prop.expressions.count<BR /> msgbox(chart.getcolumncount-iexpr)</P><P>thank you</P></BODY></HTML> Thu, 17 Sep 2009 16:59:56 GMT https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185220#M589376 2009-09-17T16:59:56Z AW:how to check dimension is expand /collapse https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185221#M589377 <HTML><HEAD></HEAD><BODY><P>&nbsp; Thanks&nbsp; astendo,</P><P></P><P>&nbsp; this is the solution i was looking for and it is working perfectly for me. </P></BODY></HTML> Mon, 16 Apr 2012 13:38:05 GMT https://community.qlik.com/t5/QlikView/how-to-check-dimension-is-expand-collapse/m-p/185221#M589377 brindlogcool 2012-04-16T13:38:05Z