Discussion Board for collaboration related to QlikView App Development.
i have a model to measure campaigns, i have cost value of the campaign level.
but 'under' campaign i have lower hierarchy like countries, users etc.
when i build a pivot table i can see the cost (sum(cost)) only in one line for the campaign and all the drill down dimensions retrieve 0/null
Seems like a data model issue. Would you be able to share your application or snapshots?
maybe i can describe it better,
i have cost in campaign level so in a pivot i can sum(cost) and count users with a user create flag sum(create_flag) this is how it looks like +-
i want to see it (cost) in user level like this:
With CAMPAIGN and USER as dimensions, use the expression:
Sum(COST) / Count(TOTAL <CAMPAIGN> USER)