If condition for the scenario

[#1]

Hi All,

I need help in writing if condition. Attached the Qvw.

All the details are mentioned in the QVW.

Regards,

Keerthi KS

[Anonymous]

Did not get you.

Both are two different reports with Draft as one and Expired as 2nd.

what exactly you want?

[#3]

Lets say Enq_contactname Mr Pavani is there with both Off_status Draft and Expired.

Since the Off_status is Draft it should not be shown in Expired table (2nd)

[Anonymous]

Is this what you want?

[Anonymous]

Suppress value null for all dimension as well

[#6]

Failed to open document

[Anonymous]

u r using personal edition?

[#8]

no got licence

[Anonymous · Accepted solution]

Use this expression in your Expired table & suppress null for each dimension

=if(Off_Status<>'Draft' and Off_Status<>'Expired',Enq_ContactName)

See the attachment