Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Announcements
Qlik's 15-week Applied Data Analytics using Qlik Sense course. Classes start Jan. 17, 2022. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Specialist
Specialist

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.

rubenmarin

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.

maxgro
MVP
MVP

in menù

tools --> Quick Chart Wizard

chose a chart type (straight table, bar chart)

date as first dimension

sum totalcon as expression

.....

morris70
Specialist
Specialist

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;

Community Browser