topic Re: Cartesian between same field in Alternate State in QlikView

Cartesian between same field in Alternate State

sunny_talwar — Thu, 30 Mar 2017 12:37:21 GMT

Hey Guys -

This is just a hypothetical question, but do we know if a same field in alternate state can behave like Cartesian Product? For example, if I have an inline load like this

Table:

LOAD * Inline [

Dim

];

and lets call the alternate state as AS. So, can we somehow do this?

Dim_From_Inherited_State Dim_From_AS_State

1 1

1 2

2 1

2 2

My testing doesn't seem to show that this is possible, but may be someone have ideas here....

What I am trying to do is avoid creating an island table like this

Table:

LOAD * Inline [

Dim2

];

and somehow make use of alternate state if possible

Re: Cartesian between same field in Alternate State

marcus_sommer — Thu, 30 Mar 2017 13:41:32 GMT

Hi Sunny,

I don't believe that you could get these functionality with alternate states but it might be possible to create such cartesian with aggr-functions whereby I'm not sure if this would be easier to handle or have a better performance than using an island table.

What is the aim behind the island table respectively the cartesian? Maybe there are other ways ...

- Marcus

Re: Cartesian between same field in Alternate State

sunny_talwar — Thu, 30 Mar 2017 13:46:18 GMT

Trying to help pedro_freire‌ here: Evaluate Chart Expression at line level - Part3 and thought that may be I can somehow use Alternate State.... Do you want to check the discussion and see if you have any ideas