Rolling data in all charts - Qlik Community

shanky1907 · ‎2017-10-30

Hello All,

I am going through an issue to represent Employee data about their trainings and completion status.

I have a simple data model with three table connected with EmpID & a master calender connected to Employee table with DOC(Date of last status change of one of the training completed).

So, in this case whenever such a month is selected in which their is no DOC for any employee, it shows blank on all Charts as Calender cant find any relation to the Month selected.

I want to change my Data model and give such condition that whenver any such empty data month is selected then it should show last available completion status.

Thanks to all in advance!

sunny_talwar · ‎2017-10-30

Check this link out

Generating Missing Data In QlikView

shanky1907 · ‎2017-10-30

Hello Sunny,

I am using the below expression in one of the chart & it gives good result but there are too many charts so the same functionality i want to apply in data model or sscript itself :

=count({1<[BU ID]={'BU1'},Status={'YES'},DOC={'<=$(vEndDate)'}>}Status)/count({1<[BU ID]={'BU1'},Status={'YES','NO'}>} Total Status)

sunny_talwar · ‎2017-10-30

This is sort of what you want right?

Month, Value, NewValue

Jan, 10, 10

Feb, , 10

March, 20, 20

April, 30, 30

May, 10, 10

Jun, 22, 22

Jul, , 22

Aug, 10, 10

shanky1907 · ‎2017-10-30

Yes, exactly. But i want to implement this in data model only. Not on charts.

shanky1907 · ‎2017-10-30

Month, Value, NewValue

Jan, 10, 10

Feb, , 10

March, 20, 30

April, 30, 60

May, 10, 70

Jun, 22, 92

Jul, , 92

Aug, 10, 102

Like this.

Rolling data in all charts

sunny_talwar · ‎2017-10-30

The link I shared above shows you how to do this in the script... check it out please