topic Re: variable problem in QlikView

variable problem

Mon, 16 Jun 2014 08:17:12 GMT

Hi,

how can i add a variable like "month(today())" to month in below set analysis. thanks

Sum({<year={2013},month={May},day={2}>}TRA_QTY)

Re: variable problem

its_anandrjs — Mon, 16 Jun 2014 08:20:51 GMT

Try with

Sum({<year={2013},month={' $ (=Month(Today()) ) '},day={2}>}TRA_QTY)

Sum({<year={2013},month={" $ (=Month(Today()) ) "},day={2}>}TRA_QTY)

Re: variable problem

MK_QSL — Mon, 16 Jun 2014 08:22:57 GMT

SUM({<year = {'$(=Year(Today()))'}, month = {'$(=Month(Today()))'}>}TRA_QTY)

SUM({<year = {'$(=Year(Today())-1)'}, month = {'$(=Month(Today())-1)'}>}TRA_QTY)

Re: variable problem

Mon, 16 Jun 2014 08:23:23 GMT

Dont you only use " when its a search string? When it should be between two months or so?

Re: variable problem

ashfaq_haseeb — Mon, 16 Jun 2014 08:23:33 GMT

Try below

Sum({<year={"$(=year(today()))"},month={"$(=Month(today()))"},day={"$(=day(today()))">}TRA_QTY)

Regards

ASHFAQ

Re: variable problem

Mon, 16 Jun 2014 08:28:49 GMT

thanks anand, I have another problem how can i get previous month?

Re: variable problem

ashfaq_haseeb — Mon, 16 Jun 2014 08:30:27 GMT

H try below

Sum({<year={2013},month={' $ (=Month(Today())-1 ) '},day={2}>}TRA_QTY)

Regards

ASHFAQ

Re: variable problem

its_anandrjs — Mon, 16 Jun 2014 08:38:10 GMT

Try with

Sum({<year={2013},month={' $ (=Month(Today())-1 ) '},day={2}>}TRA_QTY)

Re: variable problem

Mon, 16 Jun 2014 08:44:16 GMT

Hi Anand,

my variable name is currentMonth. How can i include it?

currentMonth=month(today())

Re: variable problem

Mon, 16 Jun 2014 08:46:42 GMT

i guess its a string?

Sum({<year={2013},month={ '$(currentMonth)' '},day={2}>}TRA_QTY)

Re: variable problem

its_anandrjs — Mon, 16 Jun 2014 08:48:41 GMT

Try like

Let currentMonth = Num( month(today()) ); //If Month field has numeric values then put Num in the expression other wise you can use same currentMonth = month(today())

Sum({<year={2013},month={' $ (currentMonth ) '},day={2}>}TRA_QTY)

Re: variable problem

tresB — Mon, 16 Jun 2014 08:50:41 GMT

$(=Month(Today())-1 ) -> would only work if the month field contain numeric values.. Otherwise, try with addmonths(), like Sum({<year={2013},month={' $ (=Month(AddMonths(Today(),-1 ))) '},day={2}>}TRA_QTY)

Re: variable problem

Mon, 16 Jun 2014 08:52:51 GMT

hi Ashfaq,

month should return like May not '5' and also single quotations mustn't be there.{ }. How can i do that?

Re: variable problem

Mon, 16 Jun 2014 08:56:32 GMT

Hi tresesco,

it s not working when there are single quotations inside of the brackets. is there any method without single quotations?

Re: variable problem

its_anandrjs — Mon, 16 Jun 2014 08:56:56 GMT

Put Num in the expression

In your Load statement add new field Num(Month) as NumMonth and use it in the expression but if it is in num then try

Sum({<year={2013},month={' $ (=Num(Month(Today())) ) '},day={2}>}TRA_QTY)

Re: variable problem

MK_QSL — Mon, 16 Jun 2014 08:58:28 GMT

Sum({<year={2013},month={'$(=SubField('$(MonthNames)', ';',Month(Today())-1))'},day={2}>}TRA_QTY)

Re: variable problem

tresB — Mon, 16 Jun 2014 09:00:41 GMT

If your month field values like- Jan, Feb, ... It should work with single quotes/double quotes. You could post a sample qvw so that we can find the actual issue.

Re: variable problem

Mon, 16 Jun 2014 09:02:39 GMT

Sum({<year={2013},month={ '$ (=Month(AddMonths(Today(),-1 )))' }, day={2}>}TRA_QTY)

i tried like this. but it returns value 0. but when i wrote it like this

Sum({<year={2013},month={May}, day={2}>}TRA_QTY)

it s returning values correctly. what is wrong here?

Re: variable problem

tresB — Mon, 16 Jun 2014 09:05:41 GMT

If you put single quotes directly like: =Sum({<year={2013},month={'May'}, day={2}>}TRA_QTY) Do you get the same value?

Re: variable problem

MK_QSL — Mon, 16 Jun 2014 09:05:59 GMT

Check my reply