topic Crosstable if statement in QlikView

Crosstable if statement

Wed, 18 Apr 2012 15:14:09 GMT

HI Experts

I have a load statement where it takes data from table a ( through SQL) and data from table b ( from Excel)

On the Dashboard I have a field in each table that I compare AccountSQL and AccountXL

I am looking to compare these as part of the load statement , is this possible ? as they both come FROM different tables ??

Thanks

Anonymous — Thu, 19 Apr 2012 08:47:16 GMT

I don't think that will be a problem. It doens't matter from how many sources you get your data.

Can you share a sample of your data from both data source (fe in 2 excel files) ?

Thu, 19 Apr 2012 10:31:43 GMT

Hi Denis

Im actually going to repost the qury in a bit more detail ,

I havent really explained the issue correctly I think

Thanks

jagannalla — Thu, 19 Apr 2012 10:33:46 GMT

Ok wt is this issue then.

Thu, 19 Apr 2012 10:53:47 GMT

Hi Jagan

I came up with a solution ( its hairy at best!!)

It in the post Distinct compare 2 diff tables in script

Any advice or guidance would be really appreciated

Thanks