topic Re: Straight table issue in QlikView

Straight table issue

Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I am searching on following problem.

I've created a straight table and with certain selections I generate the output below:

I don't want to see dimensions where all data is 0 or '-'. I only want to see the columns with actual data (6,5 and 4)

All options 'Suppress When Value is Null' are already flagged in the object.

Any other ideas/proposals?

Kind regards,

sunny_talwar — Wed, 14 Jun 2017 07:35:03 GMT

Is this a straight table or pivot table? In essence, 4,5,6,7,8,9 are dimensions or expressions?

Wed, 14 Jun 2017 07:37:53 GMT

Hi Sunny,

These are Dimensions, the Chart Type is a Straight Table.

Best regards,

Anil_Babu_Samineni — Wed, 14 Jun 2017 07:40:37 GMT

Will you able to provide Expression? It may help if you provide sample data

sunny_talwar — Wed, 14 Jun 2017 07:44:15 GMT

Have you checked 'Suppress Zero Values' on the presentation tab?

Wed, 14 Jun 2017 07:54:26 GMT

Yes I did. Any other options that might have influence?

vinieme12 — Wed, 14 Jun 2017 07:54:28 GMT

Will need a sample to see what's going on.

Wed, 14 Jun 2017 09:29:21 GMT

Here you go

sunny_talwar — Wed, 14 Jun 2017 11:10:10 GMT

The culprit here was division 1 which was stamping ='' a space for all your dimension values. Check this now

Wed, 14 Jun 2017 13:40:32 GMT

Hi Sunny,

Thanks for the help. I'm just struggling now with a last issue.

How do you do it if you want you division to be the first record? In this case your solution seems not to work...

Best regards,

Mathias

sunny_talwar — Wed, 14 Jun 2017 13:43:58 GMT

Lol, then change your expression to this

=If(Column(2) <> 0, '')

Since you made division1 as your Column(1), use Column(2). Alternatively, you can use =If(A <> 0, '') (Column label)