topic Excel Pivot in Qlikview in QlikView

Excel Pivot in Qlikview

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

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:

Re: Excel Pivot in Qlikview

Wed, 26 Apr 2017 13:47:53 GMT

see attached

Re: Excel Pivot in Qlikview

SK28 — Wed, 26 Apr 2017 16:57:45 GMT

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)

Re: Excel Pivot in Qlikview

Digvijay_Singh — Wed, 26 Apr 2017 17:54:48 GMT

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.