topic Re: Showing the trends in QlikView

Showing the trends

Anonymous — Sun, 04 Feb 2018 12:31:49 GMT

am showing a current view(monyear) data, bt now i need to show the trend two year's data bt it shud be dynamic, it shud pickup by default. How to do that.

Re: Showing the trends

Anil_Babu_Samineni — Sun, 04 Feb 2018 12:36:02 GMT

This information won't make to reply. But, I will try my best (This is just imagination)

Avg({<monyear = {">=$(=AddYears(Max(monyear),-2))<=$(=Max(monyear))"}>} Sales)

Re: Showing the trends

Anonymous — Mon, 05 Feb 2018 07:41:45 GMT

there has to be a dynamic script as in when we load the data from our qvd,it shud identify by default which year month u r luking at so if the qvd is refreshed in jan ,it shud uphold 12 years data

Re: Showing the trends

Anonymous — Mon, 05 Feb 2018 09:34:01 GMT

every month when new data comes in ,am not required to change monyear in the script,it shud be all automated

Re: Showing the trends

Anonymous — Mon, 05 Feb 2018 11:34:51 GMT

can u please help regarding the same.

Re: Showing the trends

Anonymous — Mon, 05 Feb 2018 12:22:51 GMT

kindly help as its a urgent requirement.

Re: Showing the trends

avinashelite — Mon, 05 Feb 2018 12:50:07 GMT

if you have a data field like Month_Year then in your load statement

LOAD

from

QVD

Where Month_Year =>MonthName(AddMonths(Today(),-12)) and Month_Year <=MonthName(Today());

NOTE: I have assumed month_Year format as e.g Feb 2018

Re: Showing the trends

Anonymous — Tue, 06 Feb 2018 12:47:39 GMT

thanks,

am doing the same thing in my where condition but its not wrking for me ,

Re: Showing the trends

avinashelite — Tue, 06 Feb 2018 13:08:00 GMT

share the sample app then will check and suggest

Re: Showing the trends

Anonymous — Wed, 07 Feb 2018 06:27:20 GMT

there is an issue with the date field format ,tahts why its not picking up I guess

how to correct the date format

Re: Showing the trends

Anonymous — Wed, 07 Feb 2018 06:41:39 GMT

so when am doing month(yearmonthfield) am getting the output as character means like dec

when am doing date((yearmonthfield),'yyyy/mm/dd' so am getting the output for month as 00

how to correct this date format

Re: Showing the trends

Anonymous — Wed, 07 Feb 2018 06:49:02 GMT

I need to substring that and pickup the month values

(201602)

so it shud pick 02

how?

Re: Showing the trends

Anonymous — Wed, 07 Feb 2018 07:00:31 GMT

its bit urgent ,kindly help

Re: Showing the trends

avinashelite — Wed, 07 Feb 2018 07:30:20 GMT

try like this

=Date(AddMonths(Today(),-12),'YYYYMM')

Where Month_Year =>Date(AddMonths(Today(),-12),'YYYYMM') and Month_Year <=Date(Today(),'YYYYMM');

Re: Showing the trends

Anonymous — Wed, 07 Feb 2018 07:41:04 GMT

I pulled out year and month two separate fields from my yearmonth,

now how to apply this addmonths condition,will it wrk the same way

Re: Showing the trends

avinashelite — Wed, 07 Feb 2018 07:46:56 GMT

no it won't ...follow the approach which I suggested

Re: Showing the trends

jasonmomoa — Wed, 07 Feb 2018 09:26:17 GMT

Which is the month year date format in your original table?

According to your business requirement, you should filter out data older than the previous 12 months. So the where clause should be there.

There must be a problem within your Date format. Please, provide more info on the MonthYear dimension so we can help you out