topic Re: Rolling data in all charts in QlikView

Rolling data in all charts

shanky1907 — Mon, 30 Oct 2017 14:35:29 GMT

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!

Re: Rolling data in all charts

sunny_talwar — Mon, 30 Oct 2017 14:39:03 GMT

Check this link out

Generating Missing Data In QlikView

Re: Rolling data in all charts

shanky1907 — Mon, 30 Oct 2017 14:47:14 GMT

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)

Re: Rolling data in all charts

sunny_talwar — Mon, 30 Oct 2017 14:50:12 GMT

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

Re: Rolling data in all charts

shanky1907 — Mon, 30 Oct 2017 15:09:02 GMT

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

Re: Rolling data in all charts

shanky1907 — Mon, 30 Oct 2017 15:10:09 GMT

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

Re: Rolling data in all charts

sunny_talwar — Mon, 30 Oct 2017 15:10:42 GMT

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