Discussion board where members can get started with QlikView.
Please can any one help me, as in QlikView 8.5 the below expression is working fine but same thing is not working in QlikView 11
=COUNT(distinct if([ Stage Name]='Fund',ID&[Cycle Hierarchy Owner]))
PN:- [Cycle Hierarchy Owner] - This is actualy the cyclic drill which is there in the dimension and we have used in the expression to group the data accordingly.
It is working fine in Qlikview 8.5 version but when i use the same thing in Qlikview 11 version its given me the error " Bad field name [Cycle Hierarchy Owner]"
Can any one help me on this..
There is a function that returns the name of the field selected within a group:
Hope that helps.
Had tried it, but it didnt work. it gvies me the same error.
First of all, in the Settings menu of the Desktop, Document Properties, Groups tab, does the group "[Cycle Hierarchy Owner]" actually exist?
Can you attach the application you're working on? Might help us to figure this out.
Assuming the group does exist, then this is how you could use GetCurrentField:
=COUNT(distinct If([ Stage Name]='Fund', ID & $(=GetCurrentField([Cycle Hierarchy Owner]))))
(I think this is right, but I 'm not sure what to do with the square brackets, so if this does not work as posted, play around a bit with the GetCurrentField parameter.
Hope that helps