topic Re: Need Help with hiding a row in QlikView

Need Help with hiding a row

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

Hi All,

This might be very basic question but i'm having difficulty in solving the issue so please help me.

The issue is i have a table box with multiple dimensions, the requirement is when one of the field has some value (text) it should omit the entire row. Tried using if conditions/ also used straight table so that i can hide the column but no luck.

Header 1

Attached is the sample data and qvw file.

As shown in the table box there are 5 dimensions and the requirement is when there is data in the "Clarification" column then it should omit the entire row.

To be more specific for example in the table box for PRT# 3834702 "Clarification" column has "under agreement" so the entire row should be omitted.

Re: Need Help with hiding a row

vardhancse — Thu, 09 Feb 2017 05:50:38 GMT

In Dimension,

Create one calculated dimension

=If(IsNull(Clarification),'Null',Null())

Enable: Supress when value is null

Re: Need Help with hiding a row

pokassov — Thu, 09 Feb 2017 05:54:00 GMT

Hello!

Check this please.

Sergey

Re: Need Help with hiding a row

Anonymous — Thu, 09 Feb 2017 06:02:07 GMT

Hi Ramya,

Check the below attachment. Is this your need ?

Re: Need Help with hiding a row

ramyasaiqv — Thu, 09 Feb 2017 06:18:41 GMT

It worked Thank you Sasi.

Re: Need Help with hiding a row

ramyasaiqv — Thu, 09 Feb 2017 06:19:37 GMT

Thank you Sergey appreciate it.

Re: Need Help with hiding a row

ramyasaiqv — Thu, 09 Feb 2017 06:22:07 GMT

Thank you Nivetha.

Re: Need Help with hiding a row

vardhancse — Thu, 09 Feb 2017 06:54:10 GMT

NP.