Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
whats the correct syntax for this?
=COUNT(TOTAL <dim1,dim2,'$(=GetCurrentField(groupeddim))',dim3> value)
cant get it working
Yeah, QlikView syntax check isn't going to like it, but put brackets around the name and it should work like the attached example.
I'm not sure about what you're trying to do exactly.
Can you tell us what the expression should do ?
Thanks
Sébastien
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.
=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
swift answer apricitiated
Try just
=COUNT(TOTAL <dim1,dim2,groupeddim,dim3> value)
bad fieldname error
Yeah, QlikView syntax check isn't going to like it, but put brackets around the name and it should work like the attached example.
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
<< 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.