topic Re: need help.... in QlikView

need help....

Thu, 09 Jul 2015 10:30:29 GMT

Hi ,

My Table is

Quater	Month	sales
Q1	jan	1
Q1	feb	2
Q1	mar	3
Q2	apr	4
Q2	may	5
Q2	june	6
Q3	july	7
Q3	aug	8
Q3	sep	9
Q4	oct	10
Q4	nov	11
Q4	dec	12

and ouput should be sum of quaters should appear for each row

Quater	Month	sales	Total
Q1	jan	1	6
Q1	feb	2	6
Q1	mar	3	6
Q2	apr	4	15
Q2	may	5	15
Q2	jun	6	15
Q3	jul	7	24
Q3	aug	8	24
Q3	sep	9	24
Q4	oct	10	33
Q4	nov	11	33
Q4	dec	12	33

thanks

Ram

Re: need help....

Gysbert_Wassenaar — Thu, 09 Jul 2015 10:32:11 GMT

Use sum(total <Quarter> sales) as expression for the Total column.

Re: need help....

MayilVahanan — Thu, 09 Jul 2015 10:34:43 GMT

Try like this

Table1:

Load * Inline

[

Quater,Month,sales

Q1,jan,1

Q1,feb,2

Q1,mar,3

Q2,apr,4

Q2,may,5

Q2,june,6

Q3,july,7

Q3,aug,8

Q3,sep,9

Q4,oct,10

Q4,nov,11

Q4,dec,12

];

Left Join

LOAD Quater, Sum(sales) as Total Resident Table1

Group by Quater;

Re: need help....

Thu, 09 Jul 2015 10:35:39 GMT

Hi ,

Try the code below:

Tab:

LOAD * INLINE [

Quater, Month, sales

Q1, jan, 1

Q1, feb, 2

Q1, mar, 3

Q2, apr, 4

Q2, may, 5

Q2, june, 6

Q3, july, 7

Q3, aug, 8

Q3, sep, 9

Q4, oct, 10

Q4, nov, 11

Q4, dec, 12

];

Tab1:

LOAD Quater,

Sum(sales) as Total

Resident Tab Group By Quater Order By Quater;

Re: need help....

Thu, 09 Jul 2015 10:46:46 GMT

Hi Ramasamy,

Thank for ur reply...