topic Re: Straight Table - hide rows with null values in QlikView

Straight Table - hide rows with null values

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

I have a straight table set up, and I'm trying hide the rows with a null value in the AvgTime01 dimension. I can't figure out how to do this. I've attached the QVW/QVD that I'm using.

Any help on this would be great.

thanks,

Re: Straight Table - hide rows with null values

sunny_talwar — Mon, 19 Mar 2018 19:53:24 GMT

Make your second expression to be 0 when the first one is null... also make sure to select the total mode of Average to see the correct sub-total

If(Len(Trim(avg(Timer01))) > 0, Avg(Timer02))

Re: Straight Table - hide rows with null values

sunny_talwar — Mon, 19 Mar 2018 19:54:25 GMT

Another way to do this would be to use search string in the set analysis

Avg({<system = {"=Len(Trim(avg(Timer01))) > 0"}>} Timer02)

Re: Straight Table - hide rows with null values

exfosteve — Mon, 19 Mar 2018 21:46:27 GMT

Works like a champ. Thanks