topic Re: How to delet Null rows in pivot table ? in QlikView

How to delet Null rows in pivot table ?

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

hey guys

i'm trying to delete a rows that doesn't contain anything in a pivot table but i cant find the solution. i dont use any dimension just expressions

here is attached picture. if somebody could help me thanks.

i can use instead of the pivot table a straight table

MK9885 — Tue, 07 Aug 2018 16:34:18 GMT

what are your expressions?

momofiore — Wed, 08 Aug 2018 08:14:58 GMT

for passengers =Sum ([# Transported Passengers]) / Sum ([# Available Seats])

for client =Sum ([# Transported Passengers])

you can put any expressions you want what the important for me is to delet the the empty row

@arvind654 thanks

MK9885 — Wed, 08 Aug 2018 14:24:22 GMT

Do you have null values in any of your dimensions (([# Transported Passengers] or [# Available Seats]) ?

Without using Dimension or Calculated dimension how are you getting values as Passenger and Client?

Usually to remove nulls you can use len trim with if condition in back end or

use set analysis like below

Sum({<[# Transported Passengers] -={0}>}[# Transported Passengers] ) / Sum ([# Available Seats])

Sum({<[# Transported Passengers] -={0}>}[# Transported Passengers] )

Can you share a sample?

vishsaggi — Wed, 08 Aug 2018 14:31:44 GMT

Can you share this qvw file where you trying this?

momofiore — Wed, 08 Aug 2018 14:44:22 GMT

no no im no using any dimensions.

you cant just set any expressions you want. important for me is to have a table without the 2 empty cells.

you cant make for example passenger -> 89/5*3 client -> 69/78-9

you can use otherwise a straigte table or a table box .

vishsaggi — Wed, 08 Aug 2018 14:55:19 GMT

Can you share the app where you having this issue?

momofiore — Wed, 08 Aug 2018 15:29:27 GMT

here you can find my applcations

vishsaggi — Wed, 08 Aug 2018 15:48:07 GMT

I believe you cannot suppress header row in pivot table. So try this in your straight table. Attached is the solution for straight table.