topic Re: How to exclude "division_key" from expression in QlikView

How to exclude "division_key" from expression

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How can I exclude the "division_key" from the inbound expression:

"sum({<[division_key]=>}ordered_quantity)"

But we can see from the below screenshot that in the "inbounds" , "blockedstock" are not linked with "division_key","SEP".

How to solve this problem.

Sample attached.

sunny_talwar — Mon, 25 Apr 2016 10:01:28 GMT

Not sure I understand your concern, would you be able to elaborate and point in your document what is the concern?

suvechha_b — Mon, 25 Apr 2016 10:05:08 GMT

The report is having "Division".

But my Inbound Orders is not linked with "Division" thus it is showing null. How can I write the expression so that the

expression of "Inbound" doesn't depend on "Division".

ThornOfCrowns — Mon, 25 Apr 2016 10:05:19 GMT

I would first suggest you have a look at the data to try to eliminate the multiple synthetic keys you have in that schema.

sunny_talwar — Mon, 25 Apr 2016 10:08:38 GMT

So you are trying to get rid of 9143 number? May be use 'Suppress When Value is Null' for the Division dimension?

suvechha_b — Mon, 25 Apr 2016 10:14:54 GMT

But I need the Model depends on [Trans Date]

means every day records to be stored.

suvechha_b — Mon, 25 Apr 2016 10:21:35 GMT

Sorry, you didnt understand me. I doesn't want to get rid for the value "9143".

My datawarehouse is having the following data :

You can see that my datawahouse is not having division. But I need the "Division" in my report.

and I need the data as,

everyday,

[Trans Date] [Value]

20160401 100

20160402 200

...

20160525 500.

ThornOfCrowns — Mon, 25 Apr 2016 10:27:55 GMT

I'm not saying drop the data, I'm saying you should look at why you've so many synthetic keys in your schema.