Excel Pivot in Qlikview

[SK28]

Row Level Sum in Qlikview.

Attached a excel File.

Please go through it and help me.

I WANT TO SUM IN ROW LEVEL.

HOW TO CALCULATE "WEEKS" COLUMN IN ADDED EXCEL SHEET.

Thanks in advance.

Expected Output:

[#2]

see attached

[SK28]

Thanks for the Reply.

My Question is HOW DID YOU CALCULATED "R1" Column( Weeks Column in Attached Excel Sheet)

expected Output:

Row Labels	2/4/2017	2/11/2017	2/18/2017	2/25/2017	3/4/2017	3/11/2017	3/18/2017	3/25/2017	4/1/2017	4/8/2017	4/15/2017	4/22/2017	Weeks
0001		1											1
0002	1	1	1	1	1								5
0005	1	1											2

Here Either it will be 1 or Blank.

So How to get WEEKS COLUMN IN QLIKVIEW....?? (1,5,2)

[Digvijay_Singh]

May be like this -

The excel table data is treated as cross table in qlikview while loading. So new field Week is created, It helps in calculating all 1's of a particular week value.