topic Re: Variable error in QlikView

Variable error

neetu_singh — Wed, 02 May 2012 16:14:57 GMT

Dear All,

Can some one help me on this, i am using a variable for max date but when i call this variable into pivot table its not working & if i used expression which is mention in variable is working fine as vMaxDate = date(max(CommonDate,'DD/MM/YYYY')). please find the below screen shot this expression is not working into variable & i need this into variable as i have to use this into set expression.

Regards

Neetu Singh

Variable error

Wed, 02 May 2012 16:24:21 GMT

Make sure in your expressions that variables are coded as below.

$(vVariable)

Stephen

Variable error

neetu_singh — Wed, 02 May 2012 16:28:14 GMT

yes, m using the same.

Variable error

neetu_singh — Wed, 02 May 2012 17:27:08 GMT

Actually, i am selecting year = 2012 & month = apr, its taking max date = 30/04/2012 which is ok.

But, if one user makes his entry on 21/04/2012. so, for this particular user max date should be '21/04/2012' instead of '30/04/2012' but its giving me '30/04/2012.

Variable error

chriscammers — Wed, 02 May 2012 17:38:21 GMT

Did you use "let" or "set" to define the value of the variable?

Variable error

neetu_singh — Wed, 02 May 2012 17:45:42 GMT

no, m defining this variable on frontent in document setting - variable tab

Variable error

Wed, 02 May 2012 18:36:46 GMT

What happens when you put the formula into a text object?

I just checked this on a document and works fine for me - I would check your data in the field...

Variable error

Wed, 02 May 2012 18:38:17 GMT

When you created the variable put the = sign before the expression in the field definition?

Variable error

jonathandienst — Wed, 02 May 2012 19:34:02 GMT

Are you saying that you want the max date to show the last date for the current user?

If so, then you will need to have some association with the username of the current user, or an if statement in the variable to check the dates againt the current user name. The best solution depends on your data model and it would be helpful if you could post your model or a sample of it.

Regards

Jonathan

Variable error

neetu_singh — Thu, 03 May 2012 05:31:10 GMT

these two fields "user" & Date are coming from the same table.

Variable error

jagan — Thu, 03 May 2012 06:36:19 GMT

Hi Neetu,

I think you have given '=' while declaring variable in front end. Remove '=' in the variable expression and use

=$(vVariableName) in your expression.

If you give '=' in variable declaration it evaluates expression and stored value in expression.

Hope the following URL help you in understanding this concept.

http://www.quickqlearqool.nl/?p=902

Hope this helps you.

Regards,

Jagan.

Variable error

neetu_singh — Thu, 03 May 2012 09:14:02 GMT

have already tried but not working

Variable error

jonathandienst — Thu, 03 May 2012 10:23:40 GMT

Neetu

The max variable needs to include the username somehow. Without your model I am guessing at fieldnames and structure, but I think you might need something like:

=Date(Max(If (User = OsUser(), CommonDate)), 'DD/MM/YYYY')

If the value in the field User does not include the domain, then use subfield to get the username

=Date(Max(If (User = Subfield(OsUser(), '\', 2), CommonDate)), 'DD/MM/YYYY')

Regards

Jonathan

Re: Variable error

jonathandienst — Thu, 03 May 2012 10:34:01 GMT

Neetu

OSUser() returns the currently logged in user. If you need this in a chart dimension, then adjust the expression accordingly.

I suggest that you get the expression to return the correct results before you put it in a variable.

Regards

Jonathan

Re: Variable error

neetu_singh — Fri, 26 Oct 2012 10:54:41 GMT

Dear All,

Its done, for this we need to create a ledger by using peak function at the backend then if user have done last entry on 21/04/2012 then from 21 to 30/04/2012 it will give the same value using peak function.

So its resolved.

Thanks for all your support.

Regards

Neetu Singh