topic Re: Use Variable in Inline Table in QlikView

Use Variable in Inline Table

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

Hi All,

I have Inline Table As:

Target:

Load * Inline [

%Target, TargetOrder, TDAchieved ,TDTarget

Session,1,'sum({<MonthID={$(=max(MonthID))}>}SpValueDaily)','sum({<IsCurrentMonth={1}>}SpValueDaily)'

];

and in text .. I have a Expression

1: $(=Maxstring(TDAchieved))

2: $(=Maxstring(TDTarget))

But my first Expression is not giving a Value .. Where i am calculating value for max month based on user selection.

if i am Writing my expression Directly sum({<MonthID={$(=max(MonthID))}>}SpValueDaily)

in Text its gives me a Output.. I need how to write same thing in inline table and use as Variable..

Kindly check and help me on this. i as Well Attaching sample data and qvw for the same.

Either how can i write set analysis on script in inline table to get max month on customer selection

Re: Use Variable in Inline Table

MK_QSL — Thu, 21 Apr 2016 12:03:36 GMT

Storing variables outside of QlikView - The Qlik Fix! The Qlik Fix!

Re: Use Variable in Inline Table

brijeshvma — Thu, 21 Apr 2016 12:12:12 GMT

Any other solution to achieve this .. Apart from this one ..Kindly help me on this.

Re: Use Variable in Inline Table

brijeshvma — Thu, 21 Apr 2016 12:38:14 GMT

Is there any Response on this ?

Re: Use Variable in Inline Table

marcus_sommer — Thu, 21 Apr 2016 12:52:36 GMT

The reason why it's not working is that you have a $-sign expansion within your first expression and they will be evaluated during the load and it results in NULL for it - if you have a look within the tableviewer on this table in preview and looked on the result from this field you will see that the expression is umcomplete and therefore couldn't be work within the gui.

One commonly used workaround for these topic is to use another char for it and replace it later, like in this example:

Target:

Load %Target, TargetOrder, replace(TDAchieved, '###', '$') as TDAchieved ,TDTarget Inline [

%Target, TargetOrder, TDAchieved ,TDTarget

Session,1,'sum({<MonthID={###(=max(MonthID))}>}SpValueDaily)','sum({<IsCurrentMonth={1}>}SpValueDaily)'

];

- Marcus

Re: Use Variable in Inline Table

brijeshvma — Thu, 21 Apr 2016 13:23:56 GMT

Hi Marcus,

thank you so much for your reply and explanation.. its working now .....:)