Where Exists

[#1]

Hi Everyone,

I have something to learn from you all.

I have two qvds and- History & Present.

In History we store the monthly snapshots and Present holds the current details.

For the Product details we need to Join them with Product qvd.

Now the requirement is to find the number of missing products from History to

Present.

There are many items which were in pending stage, and the related(corresponding) product

numbers were stored in History qvd but with due course of time, those products got

cancelled and hence later on the Present qvd we don't have those details.

SO, now my task is to find how many of those products are missing.

I guess we need to use WHERE Exists, can someone suggest me what should I do next.

Thanks and Regards,

Bikash

[#2]

Hi Everyone,

Instead of where exists what I did was a left join.

Which gave me an instant solution to my problem.

Thanks a lot everyone.

With best regards,

Bikash

[rohit214]

hiii..

hw can i use Where clause in my script....plz give an detail example

[#4]

Hi,

I have attached a simple example for you.

Hope this helps,

Please feel free if you have any further queries.

Regards,

Bikash

[rohit214]

hi...sir

thaanx for helping me ..i git ur attachment ..is helps me a lot.

now i understood hw to use.

[#6]

Hi

It's great your question has been answered...I have created a white paper on this topic and hopefully it will help broaden individual's knowledge on the topic. There are multiple ways to limit the data load which are included.

Ever have the issue of loading in data which does not really need to exist in your data model?

Would you like to maybe load in new order details which aren’t linked to a previous order ID?

Would you like to load in transactional data based on the data that already exists within your data model?

Functions exist in the QlikView script which allows the user to force only certain values to be brought in/or left out. This powerful feature can support in controlling the amount of data your qvw is holding – helping in fine tuning the performance of your dashboard and productionising your application.

Thanks,

Ricky