Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
Partner
Partner

Weird Pivote table requirement

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

90

95

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.

6 Replies
Partner
Partner

Re: Weird Pivote table requirement

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

saumyashah90
Valued Contributor

Re: Weird Pivote table requirement

YTD?

Partner
Partner

Re: Weird Pivote table requirement

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 ?

saumyashah90
Valued Contributor

Re: Weird Pivote table requirement

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

Re: Weird Pivote table requirement

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

see the attched qvw