grouped dimensions and COUNT TOTAL

[amien]

whats the correct syntax for this?

=COUNT(TOTAL <dim1,dim2,'$(=GetCurrentField(groupeddim))',dim3> value)

cant get it working

[#2]

I'm not sure about what you're trying to do exactly.

Can you tell us what the expression should do ?

Thanks

Sébastien

[amien]

COUNT(TOTAL <dim1,dim2,dim3> value)

i want to do this. only problem is that one of the dimensions is variable, because i'v created a dimension with serveral dimensions in it.

users can cycle these dimensions in the pivot charts. i need that group dimensions in the COUNT TOTAL formula because otherwise i get the wrong numbers in that expression.

[amien]

=SUM(Total <$(=GetCurrentField(GroupName))> Sales)

same as this in this threat

http://community.qlik.com/forums/t/26997.aspx

but doesnt seem to be the right syntax

[amien]

swift answer apricitiated

[pover]

Try just

=COUNT(TOTAL <dim1,dim2,groupeddim,dim3> value)

[amien]

bad fieldname error

[pover · Accepted solution]

Yeah, QlikView syntax check isn't going to like it, but put brackets around the name and it should work like the attached example.

[amien]

sum(TOTAL <[<<ProductCycle]> Sales)

why is this working? [ ] i can understand but why <<

i would haved never came up on this syntax 🙂 is this commen use?

Thanks alot btw. .. i own you a drink

[pover]

<< is just part of the name of the dimension group and is not part of the syntax. The important part is the set of brackets [ ].

Note: << is short of cyclic group and >> is short for drilldown group though I prefer to use clGroupName and drGroupName.

Regards.