QTD and YTD

[nihhalmca]

Hi All,

i need your assistance so i am sharing one of my requirement.

Sheet contains 1 container and 6 Gauge chart objects.

1. container contains 2 reports one is QTD bar chart and two is YTD bar chart.

2. If clicks QTD chart all charts (gauge) data should be displayed in QTD wise.

3. if clicks YTD chart all charts (gauge) data should be displayed in YTD wise.

Kindly share your knowledge

Thank you,

Nihhal.

[#2]

Make use of variables. Have the Variable be QTD or YTD. Then add the variable to the formula in the charts.

[stevedark]

I'm not quite sure what it is you are stuck on here.  For examples of point in time reporting you could see these example documents:

QlikView App: Simple Year To Date Example (Set Analysis)

QlikView App: Set Analysis - Prior Period Comparison

Or if it is showing and hiding different charts based on button clicks you could look at these:

QlikView App: Show and Hide Windows Dynamically

QlikView App: At The Qlik Of A Button

If you have gauge objects then you can attach actions to those to set variables to either change the expression on a chart or show/hide a chart.  Otherwise you can use a text object for the user to click on.

Hope that helps,

Steve

[rwunderlich]

I understand your problem. There is no click event in containers to know when you are switching between QTD and YTD chart. I think the best solution is to replace your container with buttons that toggle variables. Then as in the examples posted by Steve, conditionally show one chart or another based on the variables.

You can do the same thing in the gauges or you can test the variable in the expression to conditionally calc QTD or YTD.

-Rob

[stevedark]

Thanks Rob - I don't often consider the limitations of containers as I hardly ever use them.  I much prefer the control that you get from show/hide conditions driven by variables and button clicks.

- Steve