topic Re: LTD(Live Till Date) calculation in QlikView

LTD(Live Till Date) calculation

Fri, 10 Jan 2014 12:46:02 GMT

Hi All,

I have the req as per attachment.

I have to calculate the count of numbers and values based on the selections in design level through set analysis is an added advantage.

If am selecting the particular month it has to show the number and value count in that month and number and value count upto that month as well.

Total i have to show 4 fileds in staright table.

MTD NO MTD Value LTD NO LTD Value.

Here am attaching the sample data and and o/p format also.

Thanks in adv,

Ravi

Gysbert_Wassenaar — Fri, 10 Jan 2014 18:56:05 GMT

See attached qvw

Sat, 11 Jan 2014 08:17:11 GMT

Thanks Gysbert,

Its working.If its very great full if we apply the logic in design level itself.

Because currently am unable to touch the data model.

As per mine we have to create the same script in design level also like variable.But am stuck to pass the variable in set analysis.

Help the same.

Thanks,

Ravi