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: 
smilingjohn
Creator III
Creator III

Complexity

hi All,

I have a pivot table .....In which the expression are duplicating if u see in the image which has7000, 261...and so on repeating for

sevrity1, 2 3 and 4 ..... actuall it shoul display as only 7000 , 2611.... for all the severity just like Number 17.6 has all the severity ...similarly i want to show  for the expression too...

To achive this iam using below expression but still its not working as i need

PLease let me know if the expression is coorect or what needs to be done ?

sum({<ALMMasterGroup,ProjectName,ReleaseNumber,RSeverity>}TotalProjectAllocationhours)

even i tried the calculated dimension its not working ...

aggr(sum(<RSeverity,ReleaseNumber>,TotalProjectAllocationhours)TotalProjectAllocationhours)

I have attached the sample of qvw file....How do we achieve this ....

Thanks in Advance

3 Replies
lironbaram
Partner
Partner

hi

if you want the display to be like your dimension ,

you'll need to create a calculated dimension

expressions are calculated at row level.

smilingjohn
Creator III
Creator III
Author

HI Aron

Thanks for the reply I have attached the qvw file ....If I make it at dimension level then I will not be able to move the column towards right side in pivot table ....

Please do suggest

lironbaram
Partner
Partner

there is no workaround i can think of

so you can limit the total to display only in one cell