How to view column only if they are selected from fields?

[#1]

Hi:

I'm newbie in QlikView.

I'm facing an issue in Qlikview, that I have a report on yearly basis sales,-and there was a field to select the year- later on I added three more fields: half, quarter and month to get more specific sales period. and these fileds are shown as columns in the reports.

So far it's OK. But the end the user asked to hide those column (half, quarter and month) if no value is selected from their fields.

By other mean, select value <==>show column.

Any reply would be appreciated.

Saad,

[shumailh]

I think this would help you.

http://community.qlik.com/forums/t/16987.aspx

[#3]

Hi,

Create a small inline

Hide_Column:

Load * inline [

Selection,Value

Yes,1

No,0

];

In the straight table -->properties -->presentation -->select conditional for the column you wanna hide & put Value=1 inside conditional exp box.Now on front end provide field "Selection" from table above for the user to make selection Yes/No , based on that Column will get displayed.

By default column will be hidden, if u wanna show the column by default then change conditional exp from Value=1 to simply Value

[#4]

Santosh wrote:
Hi,
Create a small inline










Hide_Column:
Load * inline [
Selection,Value
Yes,1
No,0
];
In the straight table -->properties -->presentation -->select conditional for the column you wanna hide & put Value=1 inside conditional exp box.Now on front end provide field "Selection" from table above for the user to make selection Yes/No , based on that Column will get displayed.
By default column will be hidden, if u wanna show the column by default then change conditional exp from Value=1 to simply Value<div></div>

Would you please explain more detailed. As I said, I'm a just a beginner in QlikView.