how to hide the fields in a table

[sannidhikumar]

hi ALL,

how to hide the fields in a table .

Any suggestions ,

thanks

[Michiel_QV_Fan]

Can you elaborate on your question.

Do you want to be loaded and not shown?

Then you can use a hideprefix.(set HidePrefix='_';) (or suffix).

Otherwise you can drop fields entirely.

[gardenierbi]

Or tag every field you want to be hidden :

     TAG FIELD YourField WITH $hidden;

[sannidhikumar]

sander ,

i want to hide field like AAI and Details in pivot table ,

thanks

[sannidhikumar]

Michel ,

i want to hide field like AAI and Details in pivot table ,

thanks

[gardenierbi]

Add a condition to the field. For example the condition '0' to hide the field in your object.

[stevedark]

This question is not related to Qlik Web Connectors, the area you have posted into...

You do not have the same options for hiding fields in a Pivot Table as you do for a Straight table.

Why do you want to have hidden values anyway in this context?

Consider making the table a straight table rather than a pivot, or returning an empty string in the expression rather than the value.

Hope that helps.

Steve

[Michiel_QV_Fan]

Use the suggestion from Sander.

[sannidhikumar]

thanks Sander for your help .