Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Presenting data of two sucessive months in two tables

Hi,

We have developed 1 report in which we have created a table. The table shows different engagements and percentage of productive and non productive hours on those engagements. Once we click on 1 particular month in the list box data of that month should reflect in first table and data for next month should reflect in another table.

Can anyone please help in this case?

1 Reply
MVP
MVP

Presenting data of two sucessive months in two tables

Your second table could override the month selection using set analysis. If your month field is the first date of the month formatted as 'YYYY MMM', for instance, and one expression in the first table is sum(ProductiveHours), the equivalent expression in the second table might be this:

sum({<Month={'$(=date(addmonths(Month,1),'YYYY MMM'))'}>} ProductiveHours)