topic Re: Dynamic factor by client in QlikView

Dynamic factor by client

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

How would you perform this, let's see if I can explain myself properly. But I have a table with a valueName and Amount and then an Invoice column calculated by these two.

My goal is as below

So for example:

Client Value Amount Invoice

ClientA Milk 100 150

ClientB Milk 100 175

ClientC Butter 15 25

The factor here for any particular client with a specific Value I want to be able to set, change, update.

How would you do this?

Cheers

Re: Dynamic factor by client

Anonymous — Wed, 23 Mar 2016 15:51:49 GMT

Not sure I really grasp what you are trying to achieve.

I think the answer is no, but maybe you could clarify your needs ?

Re: Dynamic factor by client

Wed, 23 Mar 2016 16:02:17 GMT

So basically a smart way making the invoice value. so for clientA when he buys milk charge Amount*1,5 and the same for ClientB but charge Amount*1,75 e.g.

Re: Dynamic factor by client

Anonymous — Wed, 23 Mar 2016 16:42:11 GMT

I would think about creating this extra data externally - a spreadsheet for quick & dirty or a database for a robust solution. But where would you get the values from ? They may well already be stored on some database.

Then you can load this data into your data model as well, join it on Client and from there on it should be plain sailing