Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Shahzad_Ahsan
Creator III
Creator III

Groupwise sum in straight Table

Hi

I have Table like this:

CategoryREADING_DATEValue
17112991306042019-12-03 11:05:00.0004,977
17112991306032019-12-03 11:05:00.000461
17112991306052019-12-03 11:05:00.00065
17112991306022019-12-03 11:05:00.0000
17112991306042019-12-03 09:23:00.0004,964
17112991306032019-12-03 09:23:00.000461
17112991306052019-12-03 09:23:00.00065
17112991306022019-12-03 09:23:00.0000
17112991306042019-12-03 08:44:00.0004,957
17112991306032019-12-03 08:44:00.000461
17112991306052019-12-03 08:44:00.00065
17112991306022019-12-03 08:44:00.0000
17112991306042019-12-02 20:28:00.0004,883
17112991306032019-12-02 20:28:00.000461
17112991306052019-12-02 20:28:00.00065
17112991306022019-12-02 20:28:00.0000
17112991306042019-12-02 17:40:00.0004,869
17112991306032019-12-02 17:40:00.000461
17112991306052019-12-02 17:40:00.00065
17112991306022019-12-02 17:40:00.0000
17112991306042019-12-02 16:12:00.0004,860
17112991306032019-12-02 16:12:00.000461
17112991306052019-12-02 16:12:00.00065
17112991306022019-12-02 16:12:00.0000

 

I need Result like this:

Result column is calculated on sum of Value with same date.

I need same like in straight Table

 

CategoryREADING_DATEValueResult
17112991306042019-12-03 11:05:00.0004,9775502
17112991306032019-12-03 11:05:00.0004615502
17112991306052019-12-03 11:05:00.000655502
17112991306022019-12-03 11:05:00.00005502
17112991306042019-12-03 09:23:00.0004,9645489
17112991306032019-12-03 09:23:00.0004615489
17112991306052019-12-03 09:23:00.000655489
17112991306022019-12-03 09:23:00.00005489
17112991306042019-12-03 08:44:00.0004,9575482
17112991306032019-12-03 08:44:00.0004615482
17112991306052019-12-03 08:44:00.000655482
17112991306022019-12-03 08:44:00.00005482
17112991306042019-12-02 20:28:00.0004,8835408
17112991306032019-12-02 20:28:00.0004615408
17112991306052019-12-02 20:28:00.000655408
17112991306022019-12-02 20:28:00.00005408
17112991306042019-12-02 17:40:00.0004,8695394
17112991306032019-12-02 17:40:00.0004615394
17112991306052019-12-02 17:40:00.000655394
17112991306022019-12-02 17:40:00.00005394
17112991306042019-12-02 16:12:00.0004,8605385
17112991306032019-12-02 16:12:00.0004615385
17112991306052019-12-02 16:12:00.000655385
17112991306022019-12-02 16:12:00.00005385

 

4 Replies
vunguyenq89
Creator III
Creator III

Hi, you can use this expression

=Sum(TOTAL <READING_DATE> Value)

Hope this helps!

BR,

Vu Nguyen

Shahzad_Ahsan
Creator III
Creator III
Author

Hi 

This is working fine but I have one more question

When I use this on bar chart this does not work, its because of "Total" keyword.  

How can I show this value on bar chart  with drill down dimension Month and Days?

vunguyenq89
Creator III
Creator III

How does your expected bar chart look like (i.e which dimension and measure) ?

Shahzad_Ahsan
Creator III
Creator III
Author

Measure would be same as your above expression

There will be drill down Dimension with Month and Day

First it will show by Month, when we select any month, it should drill down to Day