in a document, I have a straight_table_object and in cell >A1< I want to have the current category (I have a drilldown group in my dimension).
I have already found out that I can get that info by using >Getcurrentselections<. The difficulty is only that this function gives me all the selections in the document - in a drilldown group, that translates into all the upper levels - if I have drilled down to the lowest level, the 2+ upper levels are all returned by the function. In that cell, however, I want only one.
I guess I can set a number in the last parameter for that function? Can anybody here tell me how do do that if I don't want to change any of the other standards? I cannot yet seem to get that right.
sorry for the delay. I don't quite understand the syntax you are using.
I can just copy-paste it and it does return something - but not quite the right thing.
It seems that QlikView is somehow sorting the selections alphabetically. So when I make one selection after another, every new one appears above the old one (in a textbox I have prepared to show this), only sometimes (depending on the letter a selection_field starts with) a new one appears below the old one and then the value returned by your formula changes.