Discussion Board for collaboration related to Qlik Education.
Hi all ,
i have 12 months of data , in which i would like to use last 3 months of data while displaying in bar chart.
for suppose i have feb 2014 to jan 2015 data , my last 3 months data should be jan 2015, dec 2014, Nov 2014
my dimensions are terc_defect
i need an expression to take last 3 months data
Thanks in advance
Go to Solution.
LOAD Date(terc) as monthterc,
you can use Addmonths( max(date), 0), Addmonths( max(date), -1), Addmonths( max(date), -2) in your set analysis
here a possible answer
Relative Calendar Fields
Last 3 Months Data in a Line Chart
Thanq all ,
could you help me writing the set analysis , i have two dimensions Monthterc and terc_defectcategory.
Thanks in advance.
Could you post small sample of your data?
(ooxml, embedded labels, table is tab1);
i gave month(terc) as monthterc
so my dimensions are monthterc and [ terc_defect category]
this is for october month data , the same way i have nov and december and also january data in another excel sheets .
What do you want to achieve on the bar?
Count the category?
Unless you have got large amount of your data it would be good practise to put them all in one sheet.