topic grouped dimensions and COUNT TOTAL in QlikView

grouped dimensions and COUNT TOTAL

amien — Wed, 29 Dec 2010 15:43:08 GMT

whats the correct syntax for this?

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

cant get it working

grouped dimensions and COUNT TOTAL

Wed, 29 Dec 2010 15:48:29 GMT

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

Can you tell us what the expression should do ?

Thanks

Sébastien

grouped dimensions and COUNT TOTAL

amien — Wed, 29 Dec 2010 15:57:55 GMT

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.

grouped dimensions and COUNT TOTAL

amien — Wed, 29 Dec 2010 21:00:02 GMT

=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

grouped dimensions and COUNT TOTAL

amien — Wed, 29 Dec 2010 21:00:41 GMT

swift answer apricitiated

grouped dimensions and COUNT TOTAL

pover — Wed, 29 Dec 2010 21:28:01 GMT

Try just

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

grouped dimensions and COUNT TOTAL

amien — Wed, 29 Dec 2010 21:35:52 GMT

bad fieldname error

grouped dimensions and COUNT TOTAL

pover — Wed, 29 Dec 2010 21:51:38 GMT

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

grouped dimensions and COUNT TOTAL

amien — Thu, 30 Dec 2010 00:06:52 GMT

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

grouped dimensions and COUNT TOTAL

pover — Thu, 30 Dec 2010 02:02:54 GMT

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