Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
leobrand
Contributor III
Contributor III

Pivot table measure

Here is a sample of my data

Dinosaur Type

Dinosaur Name

Century Named

Saurischia

Tyrannosaurus Rex

1900

Saurischia

Allosaurus

1800

Ornithischia

Triceratops

1800

Ornithischia

Tyrannosauridae

1800

Ornithischia

Hadrosauridae

1800

I am trying to turn it into a pivot table like this

Dinosaur Type

1800

1900

Ornithischia

75%

0%

Saurischia

25%

100%

How do can I modify this expression as the measure in the pivot table to do that?

([Dinosaur Type])/count(total [Dinosaur Type])

1 Solution

Accepted Solutions
Neymar_Jr
Creator II
Creator II

Hi,

Please try this -

count([Dinosaur Type])/aggr(nodistinct count([Dinosaur Type]),[Century Named])

Thanks,

RT

View solution in original post

1 Reply
Neymar_Jr
Creator II
Creator II

Hi,

Please try this -

count([Dinosaur Type])/aggr(nodistinct count([Dinosaur Type]),[Century Named])

Thanks,

RT