topic Re: straight table column hide on report open in QlikView

straight table column hide on report open

praveenr035 — Wed, 30 Sep 2015 19:45:34 GMT

Hi, I am new to Qlikview and stuck with a requirement. I have a straight table (chart) with a few bunch of dimensions and no expressions.

I've applied conditional hide =not(isnull(column_name)) (properties->presentation->conditional) to all the columns. This is working great only if I select values in other straight table (I mean only if there is a filter). If nothing is selected (or cleared all filters), my straight table is hiding columns even though it is not null. Can you please let me know how to make the column hide work all the time? Thanks in advance

Re: straight table column hide on report open

SreeniJD — Thu, 01 Oct 2015 05:06:52 GMT

Hi Praveen

By default your conditional statement is executing when you don't have additional filter or all selections cleared..

use GetSelected function for conditional hiding... so as and when you select the value, it will hide...

HTH

Sreeni

Re: straight table column hide on report open

nagarjuna_kotha — Thu, 01 Oct 2015 05:21:55 GMT

CAn u share sample file ?

Re: straight table column hide on report open

jafari_ervin — Thu, 01 Oct 2015 05:33:08 GMT

Do you have any expression in your straight table?

Re: straight table column hide on report open

settu_periasamy — Thu, 01 Oct 2015 05:36:26 GMT

Hi,

you can try this

=GetPossibleCount(Column_Name)>=1

Re: straight table column hide on report open

Thu, 01 Oct 2015 05:54:35 GMT

Try using

If( NOT ISNULL (Only(column_name)) , 0, 1)

in condition

either at Dimension or Expression

Refer attached QVW for reference

Re: straight table column hide on report open

Thu, 01 Oct 2015 05:55:35 GMT

Re: straight table column hide on report open

gautik92 — Thu, 01 Oct 2015 05:58:24 GMT

did yu try customizable straight table

have a look at this

Customizable Straight Table

Re: straight table column hide on report open

jagan — Thu, 01 Oct 2015 06:16:26 GMT

Hi,

Try like this

=GetSelectedCount(column_name) > 0

If you select any values it will display otherwise it will hide the column.

Regards,

Jagan.