topic Re: Duplicate in QlikView

Complexity

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Duplicate

lironbaram — Tue, 05 Sep 2017 06:39:08 GMT

if you want the display to be like your dimension ,

you'll need to create a calculated dimension

expressions are calculated at row level.

Re: Duplicate

smilingjohn — Tue, 05 Sep 2017 06:53:40 GMT

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

Re: Duplicate

lironbaram — Tue, 05 Sep 2017 14:22:04 GMT

there is no workaround i can think of

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