Qlik Community

QlikView Connectors

Not applicable

Date format addtional field

hai daer

Tags (1)
4 Replies

Re: Date format addtional field

Try this

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

Edited

Re: Date format addtional field

Another way is

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

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

>}MENGE)

Not applicable

Re: Date format addtional field

not working man  please check it once

MVP
MVP

Re: Date format addtional field

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).

Community Browser