Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
nihhalmca
Valued Contributor II

QTD and YTD

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.

4 Replies
Highlighted
Not applicable

Re: QTD and YTD

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: QTD and YTD

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: QTD and YTD

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

Highlighted
MVP & Luminary
MVP & Luminary

Re: QTD and YTD

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