How to hide specific columns in table box

[vireshkolagimat]

Hello All,

I have data in excel and I am showing the individual columns in table box. In some cases, the some columns will not have any data except the header column. how we can make this dynamic. If the Header has data, then i want show in the dashboard else it should not appear.

I have attached the sample data and the qvw file for your reference. Let me know for any questions.

Regards,

Viresh

[varshavig12]

You can use straight table for this.

[varshavig12]

[jagan]

Hi,

In Table box it is not possible, instead you can try Straight table with Enable Conditional option for the Dimension.

Hope this helps you.

Regards,

Jagan.

[soloeeeoff]

Hi Jagan,

Is there any possible way for 'Not having an additional expression ; And hiding a column in the straight table ' ?

Thanks

[Anil_Babu_Samineni]

From DB, If you don't have data.

Let's Assume

Ename, Sal, Company

A, 10, ABC

B, 20, DEF

Table box seems this

Ename, Sal, Company

A, 10, ABC

B, 20, DEF

After that, Feature If you don't have data using incremental Load

Ename, Sal

A, 10

B, 20

Table box seems this

Ename, Sal, Company

A, 10, ABC

B, 20, DEF

Because, Default qlik can hide the un-necessary Columns / Fields.

[vireshkolagimat]

Actually i want to show only one column in tablebox. But in straight table can we achieve this?

[varshavig12]

I didn't get you.

But if, by one column you mean one field then yes, we have single field as a dimension in straight table and put 1 in expression and hide it.

[jagan]

HI,

It is not possible.

Regards,

Jagan.