topic Can i hide a Column in Tablebox in QlikView

Can i hide a Column in Tablebox

Tue, 08 Mar 2011 08:27:15 GMT

Hi Friends,

I Wanted to Filter the Records in a Table Box depending on a flag,I wanted to Hide the Column ,is it Possible in QlikView.

Scenario:If Suppose i have all the active Employees in one Sheet,i have resigned employees in another Sheet,i have a third Page which shows the Summary of all this,if Suppose if i Come from active Emploee Sheet in Summary Detail it should show only Active Employees which we can find out through a flag.

Thanks in Advance

Can i hide a Column in Tablebox

Tue, 08 Mar 2011 08:46:27 GMT

Hi Arun,

if you data model is correct, if I don´t understand wrong, I think you just not to show dimension on tablebox. After that, show your field flag to use it as a filter.

I Hhpe it helps you

Fiber9906

Can i hide a Column in Tablebox

Tue, 08 Mar 2011 10:16:23 GMT

HI Fiber,

Thanks for ur Quick Response,i think so i coudn't deliver you the Question,my Question is Wether i can hide the Column used as Flag in Table box.

Can i hide a Column in Tablebox

Tue, 08 Mar 2011 10:46:36 GMT

Can u Please send an example

Can i hide a Column in Tablebox

Tue, 08 Mar 2011 10:50:45 GMT

Hi Arun,

Try to create a table box with all the fields you want or need, EXCEPT the Column used as flag. After that, you do right-click on the scrren and select fields... select field used as flag and show it as listboxes.

So, if you select any value from your listboxes, your table box will be filter without the field you want to hide.

Did I unterstand your question correctly? I hope so.

Fiber9906

Can i hide a Column in Tablebox

llauses243 — Tue, 08 Mar 2011 11:56:10 GMT

Hi Arun,

This is my offer (pls see image & zip), solution is a artificio vía macro.

Good luck, Luis