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

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

Sun, 25 Jul 2010 10:29:42 GMT

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,

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

shumailh — Sun, 25 Jul 2010 11:21:05 GMT

I think this would help you.

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

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

Mon, 26 Jul 2010 07:36:55 GMT

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

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

Tue, 27 Jul 2010 10:35:03 GMT


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.