Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Mismatch

Hi All,

I have apivot table ...If you look at the  last field ( Expression) TotalTime it should display only one row for all the Severity jut like Number is bieng displayed ...

How can i achieve this ?

Can someone Please Advice on this

Please find the attachment of the qvw

3 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

To get that the expression should be made as dimension.

Add below expression in dimension.

=Aggr(Sum(TotalProjectAllocationhours),ProjectName,ReleaseNumber)

And replace existing expression with Sum(distinct 1)

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
smilingjohn
Specialist
Specialist
Author

Hi kaushik this is not working ....

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Change Sum(Distinct 1) to Count(Distinct 1)

See the attached example.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!