Using QlikSense version 3.1.
Currently working on a project dealing with critical financial data which cannot be shared.
Will create one sample application to explain the requirement.
Suppose if I insert single dimension in the expression it works.
=count(total <Branch> CREST_SERIAL_NO) (works)
Since there are 10 Dimensions, I have created a Drill Down Dimension of all of them together.
and when i apply the same expression with Drill Down Grouped Dimension in it, it fails.
=count(total <grp_branch_appraiser_month> CREST_SERIAL_NO) (Does not work).
Need a solution or way to get it done.
P.S The same expression works perfectly in Qlikview.
In the Sample application in the Total measure expression the grouped dimension is not evaluated.
Same is the problem I am facing in an expression on live project data.
Please check the accuracy of expression and help me with a solution.
Sample.qvf 176.0 K