topic Re: Variable definition issue in QlikView

Variable definition issue

shyamcharan — Mon, 01 Aug 2016 05:14:28 GMT

Hi Experts,

I do have a basic table and variables created as below:

Table:

LOAD * INLINE [

    CalYrMnthNum, ThisYLM, LastYLM

    201607, 201606, 201506

    201606, 201605, 201505

];

SET vThisYLM = Max({<CalYrMthNum={"$(=Max(CalYrMthNum))"}>}ThisYLM);

SET vLastYLM = Max({<CalYrMthNum={"$(=Max(CalYrMthNum))"}>}LastYLM);

However, When I try to use the variable as =$(vThisYLM) i do not get any result.

Can anyone suggest what mistake i am doing here?

Please find the attached document.

Regards,

Shyam.

Re: Variable definition issue

Anil_Babu_Samineni — Mon, 01 Aug 2016 06:11:39 GMT

You have Date field like CalYrMnthNum

Buy, you using CalYrMthNum

Re: Variable definition issue

kaushiknsolanki — Mon, 01 Aug 2016 06:11:50 GMT

Hi,

It is because you do not have same field name in Table and in Variable.

Your variable uses "CalYrMthNum"

Where as your field name is CalYrMnthNum.

Correct it and then try.

Regards,

Kaushik Solanki

Re: Variable definition issue

shyamcharan — Mon, 01 Aug 2016 06:21:00 GMT

Hi Guys,

Thanks heaps for your responses.

Even after renaming the Field name still I have the same issue.

However, the issue seems to be around the $ sign in the load script.

I found a few tips in the link below.

Can I SET or LET a variable to include a $(=...)

Will try and find if any issues. Thanks again.

Regards,

Shyam.

Re: Variable definition issue

Anil_Babu_Samineni — Mon, 01 Aug 2016 06:35:12 GMT

PFA

Re: Variable definition issue

sunny_talwar — Mon, 01 Aug 2016 11:03:49 GMT

Try this may be:

Table:

LOAD * INLINE [

CalYrMnthNum, ThisYLM, LastYLM

201607, 201606, 201506

201606, 201605, 201505

];

LET vThisYLM = 'Max({<CalYrMnthNum={"$' & '(=Max(CalYrMnthNum))"}>}ThisYLM)';

LET vLastYLM = 'Max({<CalYrMnthNum={"$' & '(=Max(CalYrMnthNum))"}>}LastYLM)';

Re: Variable definition issue

shyamcharan — Wed, 03 Aug 2016 08:09:46 GMT

Thanks Sunny.