topic Hide and Show a Column in QlikView

Hide and Show a Column

Mon, 22 Feb 2010 20:44:27 GMT

hi everyone,

Is there a function or something to hide a column in a table?, or , how can i manipulate the conditional option to do this??, plz anyone

Regards,

Carlos

Hide and Show a Column

disqr_rm — Mon, 22 Feb 2010 21:56:36 GMT

You can create two charts and enable disable them using Conditional Show under Layout tab. You can put your codition in the conditional show so if it's true it shows one chart and second chart for false.

Other option is to add/remove dimension or expression using macros.

Edit: just recalled that in v9 it provides a conditional show/hid option under presentation. See if you can utilize that. Sorry, don't have v9 with me right now.

Hide and Show a Column

johnw — Mon, 22 Feb 2010 22:01:09 GMT

In version 9 in a straight table, you can go to Properties -> Presentation -> Columns -> Conditional. Set the condition to when you want the column to display. It sounds like you've gotten that far, and don't know what to put in the condition. But you haven't told me when you want the column to display, so I can't tell you what expression to enter there.

Hide and Show a Column

Mon, 22 Feb 2010 22:33:52 GMT

You´re right John i dont know what to put in the expression, i want that a column appears when any value of vaue field is selected.

Hide and Show a Column

johnw — Mon, 22 Feb 2010 22:40:39 GMT

OK, try getselectedcount(YourField). If there are no selections, the value will be 0 (false), so the column shouldn't display. If there are selections, the value will be > 0, which will evaluate to true, so it should display.

Hide and Show a Column

Mon, 22 Feb 2010 22:47:31 GMT

Yes, it works John thank you very much.

Regards

Carlos

Hide and Show a Column

Tue, 23 Feb 2010 00:03:23 GMT

Hey John i have a question for you, do you remember the subject of the negative and positive values in a pay chart?, it is possible that when negative and positive appear the chart automatically change to a bar chart???

Greetings

Carlos

Hide and Show a Column

johnw — Tue, 23 Feb 2010 00:14:48 GMT

Sure. Create a pie chart with this display condition:

min(aggr(sum(YourValue),YourDimension))>=0

And a bar chart with the opposite display condition:

min(aggr(sum(YourValue),YourDimension))<0

You have two charts to maintain instead of one, but if the only difference is the chart type, the most you ever have to do is delete one, copy from the other, and change the condition. So it's not actually a maintenance problem in practice.

Hide and Show a Column

Tue, 23 Feb 2010 01:49:09 GMT

Hi John again, sorry to bother you so much but i have so many question in this new software, i have a single table chart, then i select one of the values in the table and a table appears,how can i put a button that close that table without clearing the actual selections?? Because the table dissapear clicking on clear button but i need to put a button that will close that table, can you help me with that plz?

Regards

Carlos

Hide and Show a Column

johnw — Tue, 23 Feb 2010 19:52:29 GMT

Well, you can set up a button to set a variable using a macro or action, and then set up the field so that when selections are made or changed, it sets the variable differently, then use the variable in the show condition for the chart. But that seems like a whole lot of work. Why do you need to add a button to close the chart? Do you want something else to go where that chart goes? How about either using the minimize button on the chart, or using autominimize across related charts?

Hide and Show a Column

Tue, 23 Feb 2010 20:15:58 GMT

I dont know how to explian you what i have to do but i will print screen my app and maybe it will be more clear, look:

This is my dashboard on my app:

when i click in any value

then a chart appear:

this last table cover all the dashboard, actually the only way to go back to the second image is clicking in back button or clear all seletions, i need to go back to the second image without clearing the selections or without cliking on back button, do i made myself understandable?? any ideas??

Hide and Show a Column

johnw — Tue, 23 Feb 2010 20:29:29 GMT

OK, I guess I see what you're doing. My suggestions are the ones I already said, then, "set up a button to set a variable using a macro or action, and then set up the field so that when selections are made or changed, it sets the variable differently, then use the variable in the show condition for the chart" or "using the minimize button on the chart".

The first option sounds more like what you want, but it's quite a bit of work and I don't think I have any examples. Maybe someone has an example lying around, though.

Really, I'd probably just use the minimize and not have a button. The minimized chart isn't taking up much more room than a button, and to me, it makes more sense to click on a chart to see it and minimize when you don't want to see it, rather than click on a selection to see it, and clear the selection or click on a button to make it go away.

Hide and Show a Column

Tue, 23 Feb 2010 22:58:01 GMT

Thanks John, I found the answer with a macro.

Hide and Show a Column

Wed, 19 May 2010 09:12:12 GMT

Hi,

I'm having problems using Conditional. e.g. I use a simple table with customers and sales. If I only want to show the columns where sales > 100 I would use "sum(Sales)>100". Unfortunately this isn't working. Someone an idea. Thanks.

Aloah

Hide and Show a Column

johnw — Wed, 19 May 2010 17:19:44 GMT

This is a condition. It evaluates to true (-1) or false (0).

sum(Sales)>100

This is using that condition to decide whether or not to establish a value for the column. It evaluates to sum(Sales) or to null. Nulls are suppressed by default. So this will only show the rows where sum(Sales)>100.

if(sum(Sales)>100,sum(Sales))