topic Re: Opening and Closing in QlikView

Opening and Closing

Sun, 27 Oct 2013 11:44:53 GMT

i wanted to analyse inventory movement and in this regard, created a qlikview scripting with opening, net change and closing stock.

i wanted this data on a weekly basis. i always get the net change wrong.

when i export the data from database to excel, the date format is not always same. is it that the date format is giving me wrong results?

can anyone tell me how to correct date formats if all dates are not in the same format.

Clever_Anjos — Sun, 27 Oct 2013 12:47:23 GMT

Choose one format and adjust others at script level using QlikView Date functions

Sun, 27 Oct 2013 12:53:24 GMT

Dear Clever Anjos,

I tried that too.

I used the expression Date(field name).

I get the results different when i don't arrive at opening and closing.

But when i arrive at opening and closing this problem happens.

Being a non technical person, it is very difficult to understand how the system understands.

Clever_Anjos — Sun, 27 Oct 2013 12:59:37 GMT

Could you post some sample of your data?