topic How to solve this problem in qlikview? in Qlik Learning Discussions

How to solve this problem in qlikview?

Thu, 12 Feb 2015 12:52:59 GMT

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

Re: How to solve this problem in qlikview?

morganaaron — Thu, 12 Feb 2015 12:56:07 GMT

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?

rubenmarin — Thu, 12 Feb 2015 12:57:23 GMT

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.

Re: How to solve this problem in qlikview?

maxgro — Thu, 12 Feb 2015 13:07:24 GMT

in menù

tools --> Quick Chart Wizard

chose a chart type (straight table, bar chart)

date as first dimension

sum totalcon as expression

.....

Re: How to solve this problem in qlikview?

Anonymous — Thu, 12 Feb 2015 20:42:41 GMT

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;