Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Sai_Mohan
Contributor III
Contributor III

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

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 
3300010-15-2020
4400010-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

 

Labels (2)
1 Solution

Accepted Solutions
shivanisapkale
Partner
Partner

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

View solution in original post

1 Reply
shivanisapkale
Partner
Partner

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