topic Re: Using Slowly Changing Dimension in QlikView

Using Slowly Changing Dimension

Thu, 02 Jan 2014 18:02:06 GMT

Hello!

I have a small issue, I have a table like:

SEC INFO MEA

001 AAA 1

001 BBB 2

001 CCC 3

002 AAA 4

002 BBB 4

So based on the SEC I want to replace the value of INFO so the new associated value of AAA will be 4 instead of 1 and for BBB will be 4 instead of 2.

Any ideas guys?

Thanks.

Re: Using Slowly Changing Dimension

Anonymous — Thu, 02 Jan 2014 18:26:48 GMT

Does the attached give you food for thought ?

Best Regards, Bill

Re: Using Slowly Changing Dimension

Thu, 02 Jan 2014 18:32:24 GMT

I'm sorry Bill, but which attached are you talking about?

Re: Using Slowly Changing Dimension

Thu, 02 Jan 2014 18:39:36 GMT

Hi Bill,

Currently we are using Personal Edition, I am not open the QVW document, please share the script above query.

Regards,

Raja.

Re: Using Slowly Changing Dimension

iktrayanov — Thu, 02 Jan 2014 18:53:01 GMT

Here is the script out of Bill's document

He created calculated dimension SEC

=if ( aggr( rank(SEC*1) , INFO, SEC ) = 1 , SEC )

second dimension is INFO

and his expression is MEA

= only(MEA)

Re: Using Slowly Changing Dimension

iktrayanov — Thu, 02 Jan 2014 19:02:02 GMT

I will try something like

Temp:

Load

max(SEC)

group by SEC

from YourTable;

inner join (Temp)

Load

SEC,

MEA

From YourTable;

and then use this temp table to replace the MEA values.

Re: Using Slowly Changing Dimension

iktrayanov — Thu, 02 Jan 2014 19:04:09 GMT

Sorry the group by should be

Group by SEC, INFO

Re: Using Slowly Changing Dimension

Thu, 02 Jan 2014 19:04:49 GMT

Thanks IVAN Trayanov.

Re: Using Slowly Changing Dimension

Thu, 02 Jan 2014 21:34:02 GMT

Hey Bill Thanks for your response but is it anyway it can acheived with Where Exists clause?