Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ilanbaruch
Specialist
Specialist

level of details (pivot)

hi all,

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

any ideas?

advanced thanks

3 Replies
sunny_talwar

Seems like a data model issue. Would you be able to share your application or snapshots?

ilanbaruch
Specialist
Specialist
Author

Hi Sunny,

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

  

CampaignUsers#SUM(cost)
AAA50100$
BBB80144$
CCC120180$

i want to see it (cost) in user level like this:

  

CAMPAIGNUSERCOST
AAA1112$
AAA2222$
AAA3332$
AAA4442$
BBB2131.8$
BBB3231.8$
BBB4321.8$
BBB1231.8$
jonathandienst

With CAMPAIGN and USER as dimensions, use the expression:

     Sum(COST) / Count(TOTAL <CAMPAIGN> USER)

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein