Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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 u Please send an example
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