topic Re: Urgent help in QlikView

Urgent help

Anonymous — Mon, 15 Oct 2012 10:24:59 GMT

Hi,

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..

Regards,

Ankit

Re: Urgent help

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 10:28:53 GMT

Hello Ankit,

There is a function that returns the name of the field selected within a group:

GetCurrentField(groupname)

Hope that helps.

Miguel

Re: Urgent help

Anonymous — Mon, 15 Oct 2012 10:33:19 GMT

Hi Miguel,

Had tried it, but it didnt work. it gvies me the same error.

Regrads,

Ankit

Re: Urgent help

Miguel_Angel_Baeyens — Mon, 15 Oct 2012 11:22:22 GMT

Hi Ankit,

First of all, in the Settings menu of the Desktop, Document Properties, Groups tab, does the group "[Cycle Hierarchy Owner]" actually exist?

Miguel

Re: Urgent help

Mon, 15 Oct 2012 11:26:05 GMT

Hi!

Can you attach the application you're working on? Might help us to figure this out.

Cheers,

Emma

Re: Urgent help

jonathandienst — Mon, 15 Oct 2012 11:38:34 GMT

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

Jonathan