topic Cross join not working in accesspoint. in QlikView

Cross join not working in accesspoint.

Wed, 17 Feb 2016 11:29:48 GMT

The below tables are cross joined

YesNo:

LOAD * INLINE [

Y/N

Y

N

];

Mydata:

LOAD * INLINE [

Exception Flag

Y

Y

Y

Y

Y

N

N

N

];

I have created a chart with fields Y/N and Exception Flag as dimensions. Created a single expression like this.

= SUM(if([Exception Flag] = [Y/N],1,0))

The chart appears like this below in my local.

Y/N	Exception Flag	= SUM(if([Exception Flag] = [Y/N],1,0))
		8
N	N	3
Y	Y	5

When i check the same report through accesspoint, the below output is generated.

Y/N	Exception Flag	= SUM(if([Exception Flag] =[Y/N],1,0))
		15
N	Y	5
Y	Y	5
-	Y	5

But I am expecting a data like i see in my local.

Thanks in advance

Re: Cross join not working in accesspoint.

swuehl — Thu, 18 Feb 2016 11:05:31 GMT

Could you upload your sample QVW that demonstrates your issue?

Note that your tables are not cross joined in the load script, you are creating two unlinked tables.

You would need to add a JOIN prefix to really join the tables:

YesNo:

LOAD * INLINE [

Y/N

Y

N

];

Mydata:

JOIN (YesNo)

LOAD * INLINE [

Exception Flag

Y

Y

Y

Y

Y

N

N

N

];

If you are not joining the tables in the script, there will be an implicite cross join when QlikView calculates the record set for the aggregation

=SUM(if([Exception Flag] = [Y/N],1,0))