
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 | |
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
