Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

praveenr035
New Contributor II

straight table column hide on report open

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

Tags (1)
8 Replies
SreeniJD
Valued Contributor

Re: straight table column hide on report open

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

Partner
Partner

Re: straight table column hide on report open

CAn u share sample file ?

jafari_ervin
Contributor III

Re: straight table column hide on report open

Do you have any expression in your straight table?

Re: straight table column hide on report open

Hi,

you can try this

=GetPossibleCount(Column_Name)>=1

Not applicable

Re: straight table column hide on report open

Try using   

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

in condition

either at Dimension or Expression

Refer attached QVW for reference

Not applicable

Re: straight table column hide on report open

Capture.JPG

gautik92
Valued Contributor III

Re: straight table column hide on report open

did yu try customizable straight table

have a look at this

Customizable Straight Table

MVP & Luminary
MVP & Luminary

Re: straight table column hide on report open

Hi,

Try like this

=GetSelectedCount(column_name) > 0

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

Regards,

Jagan.