topic Re: BAR CHART in QlikView

BAR CHART

Sat, 03 Jan 2015 10:50:19 GMT

I want to display three months data based on selected month

for example :

i have two input box one is current selected year and another current selected month those two are variables

if i select jan 2014 it should display oct 2013 nov 2013 dec 2013

if i select april 2014 it should display jan 2014 feb 2014 mar 2014

i am getting one value only i am not getting three months

please help me

Thanks

Sivaram

Re: BAR CHART

jagan — Sat, 03 Jan 2015 11:43:02 GMT

Hi Sivaram,

Modify your script to get the date field using below script

LOAD

MonthName(MakeDate(SHIP_YEAR, Num(SHIP_MONTH))) AS MonthYear,

MakeDate(SHIP_YEAR, Num(SHIP_MONTH)) AS SHIP_DATE;

LOAD

SHIP_MONTH,

TRANSPORT_MODE,

SHIP_YEAR,

SHIP_NO

FROM

(qvd);

Now use MonthYear as dimension and use below expressions

For AIR

=Count({<TRANSPORT_MODE={'AIR'}, SHIP_DATE={'>=$(=MonthStart(MakeDate(APPAC_SelectedYear, APPAC_SelectedMonth), -3))<=$(=MonthEnd(MakeDate(APPAC_SelectedYear, APPAC_SelectedMonth), -1))'}>} SHIP_NO)

For SEA

=Count({<TRANSPORT_MODE={'SEA'}, SHIP_DATE={'>=$(=MonthStart(MakeDate(APPAC_SelectedYear, APPAC_SelectedMonth), -3))<=$(=MonthEnd(MakeDate(APPAC_SelectedYear, APPAC_SelectedMonth), -1))'}>} SHIP_NO)

Hope this helps you.

Regards,

Jagan.

Re: BAR CHART

Sat, 03 Jan 2015 12:18:27 GMT

Dear Jagan

Thank u very much

i am having SHIP_DATE date field also can u please send me qvw file that is created

i had added SHIP_DATE now plz check it

i am not getting data what u changes plz share qvw file

Thanks

sivaram

Re: BAR CHART

jagan — Sat, 03 Jan 2015 13:41:59 GMT

Hi,

Remove Timestamp from Date field using below script and see whether the given expressions are working

LOAD

SHIP_MONTH,

TRANSPORT_MODE,

SHIP_YEAR,

Date(SHIP_DATE) AS SHIP_DATE,

SHIP_NO

FROM

(qvd);

Regards,

Jagan.

Re: BAR CHART

jagan — Sat, 03 Jan 2015 13:46:12 GMT

Hi Sivaram,

Please find attached file for solution.

Regards,

Jagan.

Re: BAR CHART

Sat, 03 Jan 2015 14:32:13 GMT

Hi jagan mohan

every time i want to show three months data

i want to show if is select 1 it should show december 2013 data november 2013 october 2013 .

in ur example if is select 2 it is showing jan data

filtering show take place current month and current year

please help me in this dear urgent

Thanks

Sivaram

Re: BAR CHART

jagan — Sat, 03 Jan 2015 16:07:39 GMT

Hi,

The expressions are correct, you dont have data for that months.

Regards,

Jagan.

Re: BAR CHART

Sat, 03 Jan 2015 20:17:54 GMT

Based on our last discussion , here is your solution to FILL THE GAPS with zero values in YEARS/MONTHS. read the comments on the script on how I achieved this. NOTICE that in the attached file the 2013-Nov and 2013-Dec doesn't contain data, because you don't have data on those months. notice the little 0 on top of the date, this can be changed in properties->presentations->Zero on Bars to not display it.

Re: BAR CHART

Sat, 03 Jan 2015 20:20:14 GMT

And in the case YOU don't want to show the current selected month. then use the following expression :

ie for SEA:

replace this:

=COUNT({1 <TRANSPORT_MODE={'SEA'},YEAR_MONTH_SERIAL ={'>=$(=only(YEAR_MONTH_SERIAL)-3)<=$(=only(YEAR_MONTH_SERIAL))'}>} SHIP_NO)

for this:

=COUNT({1 <TRANSPORT_MODE={'SEA'},YEAR_MONTH_SERIAL ={'>=$(=only(YEAR_MONTH_SERIAL)-3)<$(=only(YEAR_MONTH_SERIAL))'}>} SHIP_NO)

and so on for the other expressions.

Re: BAR CHART

Sat, 03 Jan 2015 20:32:03 GMT

BUT JUST IN case , this is a modified version that doesn't include the current selected year/month.

Re: BAR CHART

Sun, 04 Jan 2015 03:14:04 GMT

Dear Mario Estrada, jagan mohan

Thanks u very much for u both

Thanks

Sivaram