topic Re: vMaxMonth variable is not working in Expression. in App Development

vMaxMonth variable is not working in Expression.

renuka_sasikumar — Mon, 13 Feb 2017 06:19:57 GMT

Hi,

When I use Count({$<MonthNumber={'$(vMaxMonth)'}>}Data) where my

vMaxMonth=Max({$<[Fiscal Year]={'$(=Max([Fiscal Year]))'}>}MonthNumber)

it's not working.

I know its very simple, but I think I am missing out something.

Can anyone help on this.

I want to show MaxMonth Data in a TextObject.

Regards,

Renuka S

Re: vMaxMonth variable is not working in Expression.

prat1507 — Mon, 13 Feb 2017 06:24:55 GMT

Hi Renuka

Try replacing $(vMaxMonth) with vMaxMonth. I hope it might work.

Regards

Pratyush

Re: vMaxMonth variable is not working in Expression.

renuka_sasikumar — Mon, 13 Feb 2017 06:28:36 GMT

Thanks Pratyush for your prompt reply.

Do you mean to say like this

Count({$<MonthNumber={'(vMaxMonth)'}>}Data_Status)

If so, then also its not working.

Regards,

Renuka S

Re: vMaxMonth variable is not working in Expression.

prat1507 — Mon, 13 Feb 2017 06:29:20 GMT

Remove the brackets, just keep the variable name.

Re: vMaxMonth variable is not working in Expression.

renuka_sasikumar — Mon, 13 Feb 2017 06:36:39 GMT

No still not working.

Regards,

Renuka S

Re: vMaxMonth variable is not working in Expression.

prat1507 — Mon, 13 Feb 2017 06:37:44 GMT

Could you please share a sample app.

Regards

Pratyush

Re: vMaxMonth variable is not working in Expression.

renuka_sasikumar — Mon, 13 Feb 2017 06:41:01 GMT

Hi,

Due to some reason I won't be able to share the sample app.

Regards,

Renuka S

Re: vMaxMonth variable is not working in Expression.

prat1507 — Mon, 13 Feb 2017 06:50:32 GMT

Please find the attached app for your reference.

Regards

Pratyush

Re: vMaxMonth variable is not working in Expression.

jonathandienst — Mon, 13 Feb 2017 06:56:27 GMT

I think you were very close. Try this:

=Count({$<MonthNumber = {"$(=$(vMaxMonth))"}>} Data)

Re: vMaxMonth variable is not working in Expression.

jonathandienst — Mon, 13 Feb 2017 07:00:27 GMT

Or redefine the variable with a leading = sign:

=Max({$<[Fiscal Year]={'$(=Max([Fiscal Year]))'}>}MonthNumber)

Then use:

=Count({$<MonthNumber = {$(vMaxMonth)}>} Data)

This assumes that MonthNumber is a simple integer.

Re: vMaxMonth variable is not working in Expression.

Anonymous — Mon, 13 Feb 2017 07:05:54 GMT

Use '=' in variable Created time .

Ex: variable Name : vCurrentYear

=Year(today)

After vCurrentYear variable use : $(vCurrentYear)

Re: vMaxMonth variable is not working in Expression.

renuka_sasikumar — Mon, 13 Feb 2017 07:15:37 GMT

Thanks,

I tried this, but it gives me wrong Count.

Regards,

Renuka S

Re: vMaxMonth variable is not working in Expression.

prat1507 — Mon, 13 Feb 2017 07:30:17 GMT

Did you check my .qvw file?

Regards

Pratyush

Re: vMaxMonth variable is not working in Expression.

jonathandienst — Mon, 13 Feb 2017 07:31:42 GMT

Then something else is going on. I suggest that you upload a small sample that illustrates the issue (and which does not need contain any sensitive data). Include the expressions you have tried and specify what result(s) you expect.

To upload a qvf file, click 'Use advanced editor'. You can upload a qvf from there,

Re: vMaxMonth variable is not working in Expression.

rahulpawarb — Mon, 13 Feb 2017 07:33:35 GMT

Hello Renuka,

If you the DateKey as date field then you can make use of below given expression:

=Count({$<MonthNumber = {"=$(=Num(Month(Max(DateKey))))"}>} Data)

Regards!

Rahul

Re: vMaxMonth variable is not working in Expression.

renuka_sasikumar — Mon, 13 Feb 2017 07:35:41 GMT

I don't have QlikView installed.

Re: vMaxMonth variable is not working in Expression.

prat1507 — Mon, 13 Feb 2017 07:38:21 GMT

Just try and declare a separate variable for =Max([Fiscal Year]) and use it instead of the function, I did the same and it worked out in qlikview.

Regards

Pratyush

Re: vMaxMonth variable is not working in Expression.

renuka_sasikumar — Tue, 14 Feb 2017 06:53:27 GMT

Hi,

I got it, I used it as

vMaxMonth=Max({$<[Fiscal Year]={'$(=Max([Fiscal Year]))'}>}MonthNumber)

Expression :

Count({$<[Fiscal Year]={"$(=Max([Fiscal Year]))"},MonthNumber={$(vMaxMonth)}>}Data)

Regards,

Renuka S