If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have Table like this:
I need Result like this:
Result column is calculated on sum of Value with same date.
I need same like in straight Table
Hi, you can use this expression
=Sum(TOTAL <READING_DATE> Value)
Hope this helps!
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?
How does your expected bar chart look like (i.e which dimension and measure) ?
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