topic Calculate week variance in QlikView

Calculate week variance

sunil1989 — Fri, 31 Mar 2017 13:12:38 GMT

Hi ,

Thanks In advance!!!!

i am having date field delivery date , which has daily date records in it ,

i have to calculate the variance on the basis of Dimension delivery date and my expression should be

count(orderid) / count(orderid) where deliverydate -7

but iam not able to handle this in set analysis can any one help on this.

Should i handle this at script level or at expression level?

i have tried below expression .

count(orderid) / count({1<DeliveryStartDateTime={"$(=date(DeliveryStartDateTime-7,'DD-MM-YYYY'))"}>}orderId)

Thanks,

Sunil

sunny_talwar — Fri, 31 Mar 2017 13:18:25 GMT

Do you have DeliveryStartDateTime as your dimension by any chance? Would you be able to share a sample?

sunil1989 — Fri, 31 Mar 2017 13:40:12 GMT

yes , DeliveryStartDateTime(delivery date mentioned above) is my deimension

i cannot share the sample because its on remote desktop, i cannot copy from remote to local machine.

sunny_talwar — Fri, 31 Mar 2017 13:44:02 GMT

If you have continuous dates, you can try this

Count(orderid)/Above(Count(orderId), 7)

sunil1989 — Fri, 31 Mar 2017 13:46:36 GMT

Any other solution?

Thanks,

Sunilkumar

sunny_talwar — Fri, 31 Mar 2017 13:50:33 GMT

This did not work? May be use The As-Of Table