topic Re: hide column in Fast change. in QlikView

hide column in Fast change.

polisetti — Thu, 27 Feb 2014 09:49:32 GMT

Hi,

In my report i have a chart ,with 3 expressions and i applied a fast change option for bar chart and straight table.In which i want to show the 3 expressions in the straight table and when we change to bar chart i want to hide one of the expression .Is it possible ?Please check the screen shot.

Re: hide column in Fast change.

Thu, 27 Feb 2014 10:01:59 GMT

try something like this:

Re: hide column in Fast change.

Thu, 27 Feb 2014 10:02:32 GMT

Hi Polisetti

In the expressions tab in the chart properties, highlight the expression that you wish to hide in the bar chart, and set it to "invisible" (check box to the right of the expression list)

This will make it invisible in the chart, but when you change to a table the column will still be there (indeed, it will remain if you copy the values or export the chart to excel also)

Erica

Re: hide column in Fast change.

Thu, 27 Feb 2014 10:03:54 GMT

As you can see in my straight table i have two expression and my barchart only shows one.

What i did was just to uncheck the bar element under propeteries for barchart -> expression .display options.

Or you could check the invisible box as Erica Whalley mentions. Remember to be under properties for your chart

Re: hide column in Fast change.

MK_QSL — Thu, 27 Feb 2014 10:03:59 GMT

Create two separate charts... one straight table and second your combo or bar chart..

Create a button and set a variable something like vVar = 1.. now on action tab add an action so that when you click on button the vVar will change to 2

Straight Table

Layout Show Conditional vVar = 1 and

Chart show conditional vVar = 2

Hope this help.

Re: hide column in Fast change.

jonathandienst — Thu, 27 Feb 2014 10:05:21 GMT

Yes it is. In Properties | General, set up the fast type changes (bar chart and straight table) and then select the bar chart in Chart Types. Now you can set up all the properties for a bar chart view. Go back to Properties | General and select the straight table in Chart Types. Now set up the straight table options - and hide the column in Properties | Presentation.

HTH

Jonathan

Re: hide column in Fast change.

polisetti — Thu, 27 Feb 2014 10:19:44 GMT

Hoo Thank you very much............