topic Re: Problem with calculated Dimension +- in QlikView

Problem with calculated Dimension +-

dominikkeller — Sat, 16 Nov 2024 01:02:14 GMT

Hello everybody,

my problem is the right expressionin my dimension.

The goal is ... I have a billing ID and a Workplace ID. In my table I have to show which outlet has which costs / income. So I have to summarize all outlets (Workplace ID / Billing ID) in my dimension and that the expression is set against each other there.

So if Outlet A lend CoWorker for $ 100 to Outlet B and Outlet C lend CoWorker for $ 50 to Outlet A the result should be

Outlet A + $ 50

Outlet B-$ 100

Outlet C-$ 50

thanks for helping me

Re: Problem with calculated Dimension +-

sunny_talwar — Tue, 17 Mar 2020 16:48:53 GMT

Where exactly are you trying to do this in the attached qvw? Also, can you provide the expected output based on the sample provided.

Re: Problem with calculated Dimension +-

dominikkeller — Tue, 17 Mar 2020 17:27:08 GMT

Hey,

good Point.

I build the table on the sheet Copy of Copy of PersoWB.

In my first file the was a mistake so here is the right one.

The Table and the expressions are what i need. But the problem is an Outlet can send & recieve coworkers from others. Untill now im just able to present which outlet is sending people or in another table which is recivieng. I hope you get the idea.

Thank you

Re: Problem with calculated Dimension +-

Brett_Bleess — Wed, 08 Apr 2020 21:00:02 GMT

@sunny_talwar another one that got lost if you have time.

Cheers,
Brett