Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
prasad_dumbre
Partner - Creator
Partner - Creator

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
prasad_dumbre
Partner - Creator
Partner - Creator
Author

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

saumyashah90
Specialist
Specialist

YTD?

prasad_dumbre
Partner - Creator
Partner - Creator
Author

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
Specialist
Specialist

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

Kushal_Chawda

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

Kushal_Chawda

see the attched qvw