variable problem

[#1]

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)

[its_anandrjs]

It seems your Month field has not proper data related to the month like there is spaces but the expression =Month(AddMonths(Today(),-1)) gives you May in the result. Before going further you need to decide what are the fields available in the data model according to that you have to use SET expression

Try Once

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

Because by hard coding you get right result and before posting the question try with post with sample data that will help a lot

But all the expression suggest by members meet your expectation check from your end or provide few lines of sample data.

Regards

Anand

[#3]

hi tresesco,

yes. it s returning values correctly

[#4]

HI all,

this is some what large application and i m unable to provide a sample because the data are privet and confidential. pls if  anyone can upload a simple application regarding this then i can understand. thanks

[#5]

hi, my months are returning like Jan, Feb....

[tresesco]

It seems that your month field is not properly created in the script. Create it in the script using month() like:

Load

          Month(DateFiel) as month

Then it should work fine.

[#7]

Month(AddMonths(Today(),-1 )))

for this I m getting "May"

[#8]

month(TRA_DATE) as month

i m creating month field like this. because i only have date field in my DB

[tresesco]

Now, it's becoming tougher without seeing your app. See here: Preparing examples for Upload - Reduction and D... | Qlik Community

[its_anandrjs · Accepted solution]

You can create different field like

Load

Month(TRA_DATE) as Month

Num(Month(TRA_DATE)) as NumMonth

From Location;

And use NumMonth field in SET analysis expression.

[#11]

Hi Manish,

this is having a error