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
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
Specialist

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

MVP

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

in menù

tools --> Quick Chart Wizard

chose a chart type (straight table, bar chart)

date as first dimension

sum totalcon as expression

.....

Specialist

Hi

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

A_tmp:
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: