straight table column hide on report open

[praveenr035]

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

[SreeniJD]

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

[nagarjuna_kotha]

CAn u share sample file ?

[jafari_ervin]

Do you have any expression in your straight table?

[settu_periasamy]

Hi,

you can try this

=GetPossibleCount(Column_Name)>=1

[#6]

Try using   

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

in condition

either at Dimension or Expression

Refer attached QVW for reference

[#7]

[gautik92]

did yu try customizable straight table

have a look at this

Customizable Straight Table

[jagan]

Hi,

Try like this

=GetSelectedCount(column_name) > 0

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

Regards,

Jagan.