Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Highlighted
Not applicable

How to solve this problem in qlikview?

hi friends

i have  date field and totalCon field in table

that table like

date         totalcon

1-aug       12323

1-aug       983

1-aug       0222

1-aug       11111

1-aug         231

2-aug       1111

2-aug       321

3-aug        234

3- aug       098

so i want sum of totalcon in date ways like 1-aug sum(12323+983+0222+11111) this so please tell me any one in chats

4 Replies
morganaaron
Valued Contributor

Re: How to solve this problem in qlikview?

If you have Date as your dimension, sum(totalcon) would give you the sum by each date.

You could use a resident load in your script and group by your date to get the totals instead if preferred.

Re: How to solve this problem in qlikview?

Hi subbu,

Create a chart and set "date" as dimension and "Sum(totalcon)" as expression.

Maybe you need to convert totalcon to number:

"Sum(Num#(totalcon, '0'))"

If you can is better to do this conversion when loading the data in script.

MVP
MVP

Re: How to solve this problem in qlikview?

in menù

tools --> Quick Chart Wizard

chose a chart type (straight table, bar chart)

date as first dimension

sum totalcon as expression

.....

morris70
Valued Contributor

Re: How to solve this problem in qlikview?

Hi

You can do this in the script if you use the function Group by.

A_tmp:
LOAD * INLINE [
date , totalcon
1-aug , 12323
1-aug , 983
1-aug , 0222
1-aug , 11111
1-aug , 231
2-aug , 1111
2-aug , 321
3-aug , 234
3-aug, 098

]
;
A:
Load date,
Sum (totalcon) As Sum_totalcon
Resident A_tmp
Group by date;

Drop Table A_tmp;