topic Re: Difference between calculated dimensions in QlikView

Difference between calculated dimensions

stevenpiers — Wed, 18 Dec 2019 11:27:38 GMT

Hi,

I have 2 different calculated dimensions (CD) which result in an itemid. CD1 checks in a hourly updated database and CD2 checks in daily updated database.

e.g. CD2 results in 5 itemId's, CD1 results 10 itemId's

Question: > What are the unique itemId's ?

Re: Difference between calculated dimensions

Gopi_E — Wed, 18 Dec 2019 11:36:12 GMT

Hi steven,

provide sample data, so it would be gives better understand what you exactly want.

Re: Difference between calculated dimensions

stevenpiers — Wed, 18 Dec 2019 11:56:51 GMT

See simplyfied sample.

Thanks in advance for your advice.

Re: Difference between calculated dimensions

Taoufiq_Zarra — Wed, 18 Dec 2019 13:02:00 GMT

can you explain your need again

Re: Difference between calculated dimensions

Gopi_E — Wed, 18 Dec 2019 13:06:26 GMT

I am not understand what exactly you want.

you created two inline tables and loaded it. but as you said the both tables having different data so there is no combination between them.

Re: Difference between calculated dimensions

stevenpiers — Wed, 18 Dec 2019 16:26:10 GMT

I'll try to explain.

There are 2 databases, one is updated hourly and the other daily.

let's say at 9 AM I know that the daily database has 10 items with an empty value

at 10 AM I see in the hourly database 13 items with an empty value

The difference of 3 is an opportunity, but most likely, because there are people working with the data... it 's possible that the actual difference is that the 10 items from 9 AM are solved and the 13 items from 10AM are new. Or perhaps partly

Does this make it any clearer?

Re: Difference between calculated dimensions

Taoufiq_Zarra — Wed, 18 Dec 2019 18:21:21 GMT

I'm not if I understand correctly.

but try the attached version.

I created a connection between CD1 and CD2 using ItemId, then the "output" table I think it answers your question

Re: Difference between calculated dimensions

stevenpiers — Wed, 18 Dec 2019 19:01:35 GMT

That's it! Thanks.... if I look at your expression I must admit I was thinking too difficult.

Again... thanks!

Re: Difference between calculated dimensions

Taoufiq_Zarra — Wed, 18 Dec 2019 19:04:26 GMT

Awesome