Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sankar_ganesh
New Contributor

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

Tags (3)
1 Reply
eruditio
Contributor III

Re: Cumulative trend view

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

Community Browser