This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Hi, I need translate this SQL query in Qlikview expression:
select distinct id_doc from table1
where event_date <= '15-03-2012'
and id_doc not in (select distinct id_doc from event_date <= '15-03-2012' and status = 'C')
Can anyone help me?Thanks.
This one should work.
INVALID_VALUES:Loaddistinctid_doc As Invalid_id_docresident event_datewhere event_date <= MakeDate(2012,3,15) and status = 'C';FINAL:NoConcatenate Loaddistinctid_docresident table1whereevent_date <= MakeDate(2012,3,15)and not exists(Invalid_id_doc, id_doc); drop table INVALID_VALUES;
id_doc As Invalid_id_doc
where event_date <= MakeDate(2012,3,15) and status = 'C';
event_date <= MakeDate(2012,3,15)
and not exists(Invalid_id_doc, id_doc)
drop table INVALID_VALUES;
thanks for the reply, however, this solution can be applied during data loading. it is possible instead to have a solution to be used in an expression?
Aggr(If(event_date <= '15-03-2012' AND status <> 'C', id_doc), id_doc)
In this case, how is your model please?
If you have 2 tables with id_doc and event_date, they should be linked. Else you can use an orphan table and function P() like in the example attached.