Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

wonkymeister
Contributor

Sum by Dimension Issue

morning,

having a nightmare this morning with a really simple problem.

using an SAP schema, so all based around start and end dates.

i have a straight table, with Age_Band as the dimension. The expression is built up of a concatenation of Day, Month and Year with a set expression to count the unique staff id's

the total number calculated is correct, only instead of splitting up the value by the dimension i get the same top level value for each row in the dimension. Ie

AgeHeadcount

201000
251000

in the above example 1000 is the sum total, not the values for 20 and 25. i'm doing something stupid im sure.

losing my mind!

3 Replies
rustyfishbones
Honored Contributor II

Re: Sum by Dimension Issue

Can you share the App or maybe the Expression

MVP
MVP

Re: Sum by Dimension Issue

May be you need to use Aggr function.

Better is you share sample data or apps !

Not applicable

Re: Sum by Dimension Issue

Use distinct Qualifier.

Please share your qvw.