Is it possible to view 18 months data in qlikview

[ferha_jafri]

Hello Everyone,

I have a query regarding the feasability of qlikview as, is it possible to view last 18 month data in qlikview because in qlikview the summation happend as if we want to calculate sum of sales per month basis ,it will take one month suppose april and add all vales for that month for all yeras so one month is present only one time so my issue is whether one month can be repeted so we can calculate 18 months data ??

Thanks in advance

With regards

Ferha Jafri.

[#2]

Try this..

Create 2qvds..(Extraction.qvd & Upload.qvd)

In Extraction.qvd take total data.

In Upload.qvd take only 18month data for application use.

create field as "YearMonth" in your Upload.qvd

Hope above method will help u..

regards-bika

[kaushiknsolanki]

Hi,

     I am not clear about what you are actually looking for.

     Kindly explain with example.

Regards,

Kaushik Solanki

[ferha_jafri]

I have a issue as in i have to show calculation for last 18 months of sales.eg when the month which i have select is may2013 then it calculate sum of sales for the last 18 months as jan1012,feb2012,mar2012,apr2012,may2012,jum2012,jul2012,aug2012,sep2012,oct2012,nov2012,dec2012,jan2013,

feb2013,mar2013,apr2013,may2013,may2013.As i know that what qlikview do it sum all the sales vales for a particular month when we take month in dimension for all the years suppose 2001,2002,2004....so is it feasable to show 18 month data in qlikview if yes them how??? plz help...i hope u understand my issue...

[calvindk]

You can use set analysis to evaluate other sets than the currently selected.

This means that even when you select a month and thus limit to current month, the set analysis can still go outside of this selection and produce the results for the other months.

[techvarun]

Use set analysis

Regards

[jagan]

Hi,

If you have date field in you data model then use the following expression

=Sum({<DateFieldName={'>=$(=MonthStart(Max(DateFieldName), -17))<=$(=Max(DateFieldName))'}, Year=, Quarter=, Month=, Week=>} MeasureName)

Note : Please make sure that the date format of you Datefield and =MonthStart(Max(DateFieldName), -17) are same.

Hope this helps you.

Regards,

Jagan.

[#8]

Try this..

SET

vLTMonth=Date(MonthEnd(AddMonths(Max(Date(DATE,'DD/MM/YYYY')),-18)),'DD/MM/YYYY')

SET vLast18Month =monthstart(vLTMonth)

In expression try below script

Sum( {<DATE={'>=$(vLast18Month)<=$(vLTMonth)'},Month=,Year= >}Value)

regards-bika

[brijesh1991]

=Sum({<DateField={'>=$(=MonthStart(Max(DateField), -17))<=$(=Max(DateField))'}, Year=, Quarter=, Month=, Week=>} Sales)

[ferha_jafri]

i got it but again my question is that can we show suppose month jan ,feb mar twice on bar chart as when we calculate 18 month for some date then there are few months which will be repeated.