Nested if

[srihitha]

What is the problem with this nested if. I am trying to use it in chart

Year1 and month1 are two fields

If( [year1] = 2013,

         If([month1] =Jan, '2013jan',

         If([month1] =Feb ,'2013Feb' )

)

)

[vinieme12]

If you just need to show month and year together as labels, I would suggest you create new field in your calendar

MonthName(Datefield) as MonthYear

or

Year(Datefield)&Text(Date(Datefield,'MMM')) as MonthYear

Then use the MonthYear field in charts

or you can combine the Year and Month field as below in a chart

Aggr([year1]&[month1],[year1],[month1])

[srihitha]

Hi Vineeth ,

I want to know how to use nested if in qlik sense load scriot and in charts.Hence, I am trying this