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: 
harjedalskok
Contributor III
Contributor III

Percentage of total connected to a dimension

Hi,

I am trying to get a percentage of faulty orders / total amount of orders

I have two dimenssions

Deliveryoffice

Faultdescription

3 expression

One that count orders with fault,

One that count total amount of orders

Since the dimension value Felfri = no faults isnt on the same raw as faults "Felborrad" or "Transportskada" the expression cant calculate it.

How should i do this calculation?

expressions used:

count ( {$ <Felkod = {'Montör'}> } (Ordernr)) All faulty orders

count ( {$ <Ordertyp = {'Order'}> } (Ordernr)) All orders

This is with selection of "helsingborg" and the second is how the table could be seen without any selection on "delivery office"

test.png

 

 

test2.png

Thanks in advance
Regards
André

 

1 Solution

Accepted Solutions
Vegar
Partner
Partner

Is this what you are looking  for?

count({$<Felkod={'Montör'}>}Ordernr)/count(TOTAL {$<Ordertyp={'Order'}>}Ordernr)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Vegar
Partner
Partner

Is this what you are looking  for?

count({$<Felkod={'Montör'}>}Ordernr)/count(TOTAL {$<Ordertyp={'Order'}>}Ordernr)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post