Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sankar_ganesh
Partner
Partner

Cumulative trend view

SalesDateProductSales
08-Maya5
10-Maya10
12-Maya25

Hi , above table is the source data for one of my reports. I need to create a table shown below to create a type of cumulative view which shows latest sales for each calendardate . Calendardate is in an inline table. Identifying latest results for each calendardate should be done in the UI expression as it has to be a dynamic one .

Could some one help me to achieve this ? Thanks!

CalendarDateLatest Sales
08-May5
09-May5
10-May10
11-May10
12-May25
13-May25
14-May25

Regards,

Sankar

1 Reply
eruditio
Partner
Partner

The ideal would be that on load (using the peek function), you would fill the missing values with the required figure and identify them using a certain flag (1 for filled, 0 for null)

Then, in the front-end, you would create expressions that would calculate the sum using set analysis for values Flag = 1.

That should give you both the required results to be displayed while giving you the correct sums.

That is the easiest solution that I can think of.

If you need more guidance, reach out.

Cheers,


Antoine