How to add more than one column in exists() in QlikSense?

[Sai_Mohan]

Hi Team,

I have requirement in which I need to add another column to my exists condition. 

Assume, there is two column. one is item_no, another column is date, when it is created.

In exists condition, firstly, I had only one column in excel 'Item_no' which i loaded in qliksense and i have written exists() to avoid duplicate values. In that item_no  column, I had two values '00011, 00022'. For this both values i had null values in the duplicated one so i removed it easily using this condition below,

(Exists(Item_no, ItemNo) AND NOT IsNull(ItemId) )
OR NOT Exists(Item_no, ItemNo)   // If the itemID has null values in it , then those values need to be excluded.

Above things are working fine, now i got another set of new item_no in which there is no null values. so i need to filter it using create date.

This is my excel file. First two values sorted using null values of another column. Last two values need to be sorted using second column. 

Item_no	Create_Date
11000
22000
33000	10-15-2020
44000	10-16-2020

In Data load editor:

LOAD
[Item_no],
[Create_Date]

FROM $(ExcludedItem_LookupFile)
(OOXML, EMBEDDED LABELS, TABLE IS Sheet1);

For this I have written exists condition as 

1. (Exists([Item_no] & [Create_Date], ItemNo & Createdate) AND NOT IsNull(ItemID) )
OR NOT(Exists([Item_no] & [Create_Date], ItemNo & Createdate).  //  It was giving error.

2. Exists(Item_no,ItemNo) and Exists (Create_Date, Createdate) AND NOT IsNull(ItemID) // Given two seperate exists condition it was also throwing error

Please help me with this ASAP.

Thanks,

Sai

[shivanisapkale · Accepted solution]

Hi,

Try using or between 2 exists statements. if this doesnt work load each exists statement table separtely then again use exists on 1st table so all the values having created tabke null which are in table 1 will be removed and will be taken from table 2 and concat that data

Regards,

Shivani