Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Shahzad_Ahsan
Creator III
Creator III
‎2019-12-07 02:57 PM

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

 

459 Views
4 Replies
vunguyenq89
Creator III
Creator III
‎2019-12-09 11:16 AM

Hi, you can use this expression

=Sum(TOTAL <READING_DATE> Value)

Hope this helps!

BR,

Vu Nguyen

454 Views
0 Likes
Shahzad_Ahsan
Creator III
Creator III
‎2019-12-10 01:01 AM
Author

In response to vunguyenq89

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?

437 Views
0 Likes
vunguyenq89
Creator III
Creator III
‎2019-12-10 05:16 AM

In response to Shahzad_Ahsan

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

429 Views
Shahzad_Ahsan
Creator III
Creator III
‎2019-12-10 05:47 AM
Author

In response to vunguyenq89

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

 

425 Views
0 Likes