topic Re: Date format addtional field in QlikView

Date format addtional field

Mon, 26 Jan 2026 21:26:37 GMT

hai daer

Re: Date format addtional field

CELAMBARASAN — Sat, 22 Dec 2012 11:38:15 GMT

Try this

=if(BUDAT<Date(VstartDate,'DD-MM-YYYY'),sum({<SHKZG ={'S'}>}MENGE) - sum({<SHKZG ={'H'}>}MENGE))

Edited

Re: Date format addtional field

CELAMBARASAN — Sat, 22 Dec 2012 11:40:32 GMT

Another way is

sum({<SHKZG ={'S'}, BUDAT={"<$(=Date(VstartDate,'DD-MM-YYYY'))"}>}MENGE) - sum({<SHKZG ={'H'}

, BUDAT={"<$(=Date(VstartDate,'DD-MM-YYYY'))"}

>}MENGE)

Re: Date format addtional field

Sat, 22 Dec 2012 11:51:11 GMT

not working man please check it once

Re: Date format addtional field

swuehl — Sat, 22 Dec 2012 14:51:23 GMT

It would be much easier if you could post a small sample app that demonstrates your problem.

One possible issue could be the fact that you defined a variable start Date that seems not to be the same you are using in the expression (VstartDate), and is probably not valid syntax anyway (I think you should use a single word literal as variable name). Then, you defined the variable using a date in 2000, but your BUDAT dates start in 2010, as far as I can see.

There are lot's of other possible issues (e.g. depending on your data model, the context you want to use the expression in, syntax errors, etc).