topic Re: QV12 pivot table based on month selection in QlikView

QV12 pivot table based on month selection

gaddeonline — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have a very complicated question. I am using QV12 and I have a pivot table in my document along with financial years and months.

My requirement is, when we click on financial year and a particular month(Dec in this case)- I want 2016/17 Jul-Dec data in YTD total.

How do I achieve that? The formulas using in achieving the results in both 2016-12 column and YTD Total are same. I think that's the problem but unable to find the solution.

Thanks and Regards

Mahesh Gadde

Re: QV12 pivot table based on month selection

Anil_Babu_Samineni — Thu, 15 Jun 2017 05:32:06 GMT

Would you able to provide sample work file

Re: QV12 pivot table based on month selection

jonathandienst — Thu, 15 Jun 2017 06:19:31 GMT

It would be a good idea to at least show the two expressions that you would like 'fixed'. That way, we are not all guessing.

Also do you have a master calendar with fiscal months and years?

Re: QV12 pivot table based on month selection

gaddeonline — Thu, 15 Jun 2017 21:55:50 GMT

Hi Anil,

I don't have rights to attach qvw file. But i am elobarating the issue with dimensions and measures i used in this pivot table.

Re: QV12 pivot table based on month selection

gaddeonline — Thu, 15 Jun 2017 22:07:15 GMT

@Hi Jonathan, @Anil babu samineni

the measures i am using in this pivot are,

ABFOOS:

Sum(If([ABF Hospital Flag] = '1' and [ABF Tier2 Flag] = '1' and [ABF Clinic Flag]='0' and NWAU_VERSION = [NWAU Version] and Match(FUNDING_GROUP_FOR_TARGETS_CODE, '01', '02', '03'), NAP_FINAL_NSW_TOTAL_OOS_COUNT))

ABFSE:

Dimesnions are,

Top Level Facility Name, Second Level Facility Name, Reporting Financial Yera and Reporitng Period YYYY MM. The last two dimensions are dragged in to columns side to make it look like a cross table.

As I said earlier, the results of the pivot either in months columns or in YTD column are deriving from the same formula.

The fiscal/financial years and months are coming from master calendar and it is linked to data by a common filed.

Re: QV12 pivot table based on month selection

gaddeonline — Fri, 07 Jul 2017 05:50:20 GMT

@Jonathan Dienst,

I am still struggling to find the solution. Do you have any solution for this issue?

Thanks and Regards

Mahesh Gadde