topic Re: Multiple step measure expression in App Development

Multiple step measure expression

leobrand — Wed, 04 Jul 2018 03:39:19 GMT

Here is Pivot Table 1

It is based on Table A below

Using the same Table A above I want to create Pivot Table 2 so it looks like this

If I were able to create measures based on Pivot Table 1 to create Pivot Table 2 they would look like this (not Qlik Syntax).

Sum(Saurischia)/Count (Century Named) / (Sum(Saurischia + Ornithischia)/Count (Century Named))

Sum(Ornithischia)/Count (Century Named) / (Sum(Saurischia + Ornithischia)/Count (Century Named))

However, I am looking for one measure based on Table A that will create Pivot Table 2. Can you help?

BalaBhaskar_Qlik — Wed, 04 Jul 2018 06:35:05 GMT

May be like this:

Sum({<[Dinosaur Type] = {"Saurischia"}>}Instances)/

Count({<[Dinosaur Type] = {"Saurischia"}>}[Century Named])

Sum({<[Dinosaur Type] = {"Ornithischia"}>}Instances)/

Count({<[Dinosaur Type] = {"Ornithischia"}>}[Century Named])

leobrand — Wed, 04 Jul 2018 21:01:30 GMT

Hi Bala Bhaskar, I updated the question to make it clearer

petter — Thu, 05 Jul 2018 10:52:12 GMT

For your first Pivot you have an expression:

Count([Dinosaur Type])

For your second Pivot you can calculate the percentages directly like this:

Count([Dinosaur Type]) / Count(TOTAL [Dinosaur Type])

And then select number format as %

In Qlik Sense or QlikView you can't create expression based on results from other charts/tables.