topic Logic help in QlikView

Logic help

ganeshreddy — Mon, 26 Oct 2015 14:58:46 GMT

Hi All,

I am having trouble while implementing code for qvd generation. Here in the attached code i am getting KPI(newly added fields) data for only the months of Sep 2015 and Oct 2015, but according to the requirement i need to calculate July 2015 KPI first to add to summary qvd after that i need to add August 2015 KPIs to it and so on. Please help to implement this code and please find the attached file.

Note : we can hardcode month names in script .

Best Regards,

Ganesh

Re: Logic help

marcus_malinow — Mon, 26 Oct 2015 15:04:25 GMT

Ganesh,

in your KPI 1to 8 loads you have a condition:

and wo_completionDate >= Addmonths(monthStart(Today()),-1) and wo_completionDate <= monthEnd(Today())

If you remove this you'll generate data for all periods.

Marcus

Re: Logic help

ganeshreddy — Mon, 26 Oct 2015 20:00:15 GMT

Hi All,

Can anyone help me on this.

Thanks in advance,

Best regards,

Ganesh