topic Re: Showing Data: Table (1 month) & Chart (13 month) in QlikView

Showing Data: Table (1 month) & Chart (13 month)

nwilliams — Tue, 09 Jun 2015 07:24:55 GMT

Hi,

I have a data set of 15 months worth of HR data. I have a list box with the "MonthName" in it. What I am trying to achieve is:

When you select a "MonthName" the table will show details relating to that month, and the chart will show data for that month, plus the last 12 months, split out using "MonthName" as a dimension.

Any ideas?

Re: Showing Data: Table (1 month) & Chart (13 month)

sushil353 — Tue, 09 Jun 2015 07:46:58 GMT

Hi,

In the chart you can write your expression as Sum({<MonthYear = {">=$(=Addmonths(Max(MonthYear),-12)) <=$(=Max(MonthYear))"}>}Sales)

HTH

Sushil

Re: Showing Data: Table (1 month) & Chart (13 month)

nwilliams — Tue, 09 Jun 2015 08:16:03 GMT

Great!!! Thanks!!!

Re: Showing Data: Table (1 month) & Chart (13 month)

prashantbaste — Tue, 09 Jun 2015 08:58:28 GMT

Please find attached QVW & let me know if it resolves your query.

Regards,

Prashant P Baste

Re: Showing Data: Table (1 month) & Chart (13 month)

nwilliams — Wed, 18 Oct 2017 10:31:26 GMT

Hi,

The above has been working great until now. When I try and put the above in the below formula, it doesn't work

=(
Sum(Aggr(Sum(DISTINCT
{<[QueueInteractionsView.c_QueueGroup]={'Service Desk'}>}
InteractionsView.TotalQueueTime), lnk_InteractionId))
/
Count (DISTINCT
{<
[QueueInteractionsView.c_QueueGroup]={'Service Desk'}>}
QueueInteractionsView.IID))

The above formula gives me an ava wait time. what I want to do is chart this over 12 months, but have the current month selected in the calendar. Any thoughts?