topic Re: Need Suggesition in QlikView

Need Suggesition

Anonymous — Wed, 27 Sep 2017 06:00:59 GMT

Hello All,

This requirement is bit different.

I generated report with data of number of new joiners in the month of Aug 2017 (Example 20) and I published.Some changes happened in the back end and new joiners numbers changed to 19. Here the issue is I want to keep the same old value 20 when ever I generate the report. It would be great if any one provide the suggestions.

Regards,

Ram

Re: Need Suggesition

Anil_Babu_Samineni — Wed, 27 Sep 2017 06:30:10 GMT

I believe you need to use identifies with in set analysis like {1}

Re: Need Suggesition

Anonymous — Wed, 27 Sep 2017 07:07:39 GMT

Hello Anil,

Thanks for reply, {1} gives the count irrespective of the current selection. The changes happing in backend. The statistical data should match when ever I generate the report. I know its difficult as we all qlik works on real time data, but for statistical purpose the data should be same

Ex: Report generated for month Aug-2017 with x records

if I generate the report after 6 months for same Aug-2017 it should be x records even data updated in the backend.

suggest me with all possible solutions.

Regards,

Ram

Re: Need Suggesition

Anil_Babu_Samineni — Wed, 27 Sep 2017 07:29:26 GMT

I am assuming, If you have Data for particular date I may write something like below

Variable like this -- LET Variable = Max(Date); OR

// SET Variable = 'Date for constant max date where last reload';

and expression like below -- Sum({<Date = {'<=$(Variable)'}>} Sales)