topic Is it possible to have a global where on multiple source loading in QlikView

Is it possible to have a global where on multiple source loading

Mon, 21 Apr 2014 09:44:29 GMT

I want to create a table that concatenates data from many data sources based on a date , the question is : Do i have to put the where condition on each data source Load , or can i put one condition at the end of the all the loads that can be applied to all of them ?

Re: Is it possible to have a global where on multiple source loading

ashfaq_haseeb — Mon, 21 Apr 2014 09:47:02 GMT

Hi,

You have to write where condition at each Data source load, I would suggest you to define the value in a variable and use where conditions with variable.

Hope it helps

Regards

ASHFAQ

Re: Is it possible to have a global where on multiple source loading

its_anandrjs — Mon, 21 Apr 2014 09:48:06 GMT

When concatenate the field name should be same specially for Date field and yes how data looks according to that you have to use Where condition if you have sample data so provide that.

Re: Is it possible to have a global where on multiple source loading

maxgro — Mon, 21 Apr 2014 10:00:34 GMT

see ashfaq answer

or (not efficient but if you have few data)

- concatenate all your tables without where in table1

- do a resident load of table1 with one where condition (result is table2)

- drop table1