Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

grouped dimensions and COUNT TOTAL

whats the correct syntax for this?

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

cant get it working



1 Solution

Accepted Solutions
Highlighted
Luminary
Luminary

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

View solution in original post

9 Replies
Highlighted
Not applicable

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

Can you tell us what the expression should do ?

Thanks

Sébastien

Highlighted
Specialist
Specialist

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.

Highlighted
Specialist
Specialist

=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

Highlighted
Specialist
Specialist

swift answer apricitiated

Highlighted
Luminary
Luminary

Try just

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

Highlighted
Specialist
Specialist

bad fieldname error

Highlighted
Luminary
Luminary

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

View solution in original post

Highlighted
Specialist
Specialist

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

Highlighted
Luminary
Luminary

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