topic Re: Weird Pivote table requirement in QlikView

Weird Pivote table requirement

prasad_dumbre — Fri, 19 Jul 2013 09:49:42 GMT

Dear All,

We are having this particular req. at one of our client; They want to analyze week wise performance.

WEEK 1

WEEK 2

TOTAL

YTD

CHANNEL

SUB_CHANNEL

CUSTOMER

BUDGET

TARGET

ACTUAL

BUDGET

TARGET

ACTUAL

BUDGET

TARGET

ACTUAL

BUDGET

TARGET

ACTUAL

TOTAL

EBO

Total

100

105

102

200

195

197

EBO-OR

Total

W101

W102

EBO-SOR

Total

W103

W104

On selection week only that week will be visible, Total will show the total value of all selected weeks; While YTD will show YTD value irrespective of week selection.
Here we are facing a issue, we have done till total part but got stuck when in YTD part

Any help would be appricated. . .

Thank You.

Re: Weird Pivote table requirement

prasad_dumbre — Fri, 19 Jul 2013 10:26:26 GMT

In case of any doubt, let me know . . .

Re: Weird Pivote table requirement

saumyashah90 — Fri, 19 Jul 2013 10:56:20 GMT

YTD?

Re: Weird Pivote table requirement

prasad_dumbre — Fri, 19 Jul 2013 11:01:57 GMT

Hi Saumya,

YTD (Year Till Date), We have to calculate value from start of the financial year till now. This is not the problem. Problem is with this perticular format. . .

Got it ?

Re: Weird Pivote table requirement

saumyashah90 — Fri, 19 Jul 2013 11:05:13 GMT

You can youse Max(Date)....by which we will get the latest date from the column

Re: Weird Pivote table requirement

Kushal_Chawda — Fri, 19 Jul 2013 17:16:47 GMT

Hi prasad,

You can create the YTD flag in back end, and you can exclude week selection from chart using set analysis.

See the attached qvw

Re: Weird Pivote table requirement

Kushal_Chawda — Fri, 19 Jul 2013 17:18:16 GMT

see the attched qvw