Discussion Board for collaboration related to Qlik Education.
i have date field and totalCon field in table
that table like
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
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.
Create a chart and set "date" as dimension and "Sum(totalcon)" as expression.
Maybe you need to convert totalcon to number:
If you can is better to do this conversion when loading the data in script.
tools --> Quick Chart Wizard
chose a chart type (straight table, bar chart)
date as first dimension
sum totalcon as expression
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;