topic Re: Passing many variable results into table to provide final expression in QlikView

Passing many variable results into table to provide final expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi - First ever blog so any help appreciated

I have 3 variables created which enable a user to select a client name, project lead name and time scale which look up (match) and return additional data

After the user selects the client name, project lead name and timescale I have 3 separate straight tables that shows the names and their associated costs and also their delivery timing, example table outputs are:

Table 1

Bob $300

Table 2

Joe $450

Table 3

Time 15 Days

All I need to do is then create a textbox to add the two cost values together and multiply by number of days

Re: Passing many variable results into table to provide final expression

sunny_talwar — Tue, 22 Aug 2017 11:13:46 GMT

Is this for QlikView or Qlik Sense? Also, what is the issue that you are running into?

Re: Passing many variable results into table to provide final expression

Tue, 22 Aug 2017 11:24:44 GMT

Hi Sunny

Qlikview

So the variable outputs that give me costs based on user selecting a name are

Table 1 ; if(case_manager=assignee_name,[Weighted Costs]/220)

Table 2 ; if(Assignee=assignee_name,[Weighted Costs]/220)

Table 3; if(POI=custmonth,(avg(compdays))) ......POI is the date variable.

I tried just to place a sum function in textbox adding the 2 costs returned then multiply by days, all that gets returned is either 0 or -

Re: Passing many variable results into table to provide final expression

sunny_talwar — Tue, 22 Aug 2017 15:30:33 GMT

May be this?

(Only({<assignee_name = {'$(case_manager)'}>} [Weighted Costs]/220) + Only({<assignee_name = {'$(Assignee)'}>} [Weighted Costs]/220))/Avg({<custmonth = {'$(POI)'}>} compdays)

Re: Passing many variable results into table to provide final expression

Wed, 23 Aug 2017 06:43:57 GMT

Spot on, many thanks Sunny, not come across the 'Only' function, more training required

Re: Passing many variable results into table to provide final expression

sunny_talwar — Wed, 23 Aug 2017 11:00:37 GMT

You can check this out

How to use - Only()

Also, if you have got what you needed, I would suggest you to close this thread down by marking the correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny