topic Re: Hide and show column in QlikView

Hide and show column

SMAKI — Wed, 25 Nov 2020 16:16:04 GMT

Hi I'm very new to qlikview. could you please help me to provide the best way to learn how to 1. hide 3 columns based on another column value

eg: I want to hide column1, column2, column3 based on column4 where the column4 value like 'ABC%' and show if the column4 value like 'XYZ%'

Re: Hide and show column

Somasundaram — Thu, 10 Jan 2019 09:43:40 GMT

hi,

Use expressions-> conditional provide the condition, based on the condition it will show /hide the column.

Re: Hide and show column

shiveshsingh — Thu, 10 Jan 2019 09:52:45 GMT

You can put conditional expression to cater this requirement in qlikview.

Re: Hide and show column

jonathandienst — Thu, 10 Jan 2019 10:02:58 GMT

That's a little confused. You want to hide the column based on a single value in another column? Which value - from the first row, last row ....

Re: Hide and show column

SMAKI — Fri, 11 Jan 2019 01:09:41 GMT

Thanks. How does the condition looks like?

sorry i'm very new and i don't even know the syntax of qlikview

eg:
something like that?

if( column4 like 'ABC%', 'hide column1 + column2 + column3', 'show column1 + column2 + column3' )

Re: Hide and show column

SMAKI — Fri, 11 Jan 2019 01:11:33 GMT

Actually it is something like batch number i capture in a column. So if the batchnumber starts with 'ABC%' for any row, i want to show another 3 columns, if not i want to hide those columns..

Re: Hide and show column

SMAKI — Mon, 14 Jan 2019 03:00:01 GMT

Hi Please reply..

Re: Hide and show column

SMAKI — Mon, 14 Jan 2019 03:00:14 GMT

Pls reply