topic Re: Jan to till selected months data should display.. in QlikView

Jan to till selected months data should display..

Tue, 19 Mar 2013 06:36:58 GMT

Hi All,

I have a bar chart,Line chart and combo chart in my application in all the charts month is a dimension,it is working fine.I have year and month in list boxs.

Now i have a requirement, when i select the Year=2013 and month=Feb in list box the bars and lines should display jan and feb,if i select mar the bars and lines should display jan,feb and mar.....like this i wnat to display the max(year) jan month to till selected months should display in all the charts.

thanks in advance...

regards,

baru

Re: Jan to till selected months data should display..

nirav_bhimani — Tue, 19 Mar 2013 06:51:29 GMT

Hi,

Try this Expression

sum({<CalDate = {">=$(=Date(Yearstart(max(CalDate))))<=$(=max(CalDate))"},CalMonth=,CalQuarter=>}Sales)

Regards,

Nirav Bhimani

Re: Jan to till selected months data should display..

kaushiknsolanki — Tue, 19 Mar 2013 06:53:28 GMT

Hi,

Have a look at the attachment.

Regards,

Kaushik Solanki

Re: Jan to till selected months data should display..

Tue, 19 Mar 2013 07:31:45 GMT

Hi Kaushik and Nirav

thanks for your reply,

I already tryed this in my application,but its not working.

May be i am using sets in 2 if conditions having flags.

Thats is the problem i am not getting the exact output....

thanks for ur help....

any other solutions...

regards,

baru

Re: Jan to till selected months data should display..

kaushiknsolanki — Tue, 19 Mar 2013 07:34:03 GMT

Hi,

Could you please tell us in detail what you are doing to achieve this.

Regards,

Kaushik Solanki

Re: Jan to till selected months data should display..

Tue, 19 Mar 2013 07:49:35 GMT

Hi,

pls check my expression:

=if(metrics = 'Value',if(Group='Total',
Sum({<IsTotal = {'Y'},CommonYear = {"$(=max(CommonYear))"},CommonMonth={"<=$(=max(CommonMonth))"}>}NETSaleVal)/100000
,

Sum({<CommonYear = {"$(=max(CommonYear))"},CommonMonth={"<=$(=max(CommonMonth))"}>}NETSaleVal)/100000)
,if(Group='Total',Sum({<IsTotal = {'Y'},CommonYear = {"$(=max(CommonYear))"},CommonMonth={"<=$(=max(CommonMonth))"}>}NETSaleQtyAFClaimConv),
Sum({<CommonYear = {"$(=max(CommonYear))"},CommonMonth={"<=$(=max(CommonMonth))"}>}NETSaleQtyAFClaimConv)))

this expresion i am using pls check....

regards,

baru

Re: Jan to till selected months data should display..

Tue, 19 Mar 2013 07:53:34 GMT

After using this exression,

i am getting the correct formate but data is showing wrong.

when i click on 2012,oct month the bars is showing jan-oct,but oct data is correct and jan-sep data is showing wrong...

whaen i remove the selection in month list box all the months is showing correct data...

thanks in advance...

baru

Re: Jan to till selected months data should display..

Anonymous — Tue, 19 Mar 2013 08:30:12 GMT

use

sum({<Year={$(=max(Year))},Month={ '<= $(=max(month))' } >}sales )

by default it will show max year max month data like for current year 2013 upto march in your bars and lines

and if you select feb then it will show bars jan and feb

Regards,

anant

Re: Jan to till selected months data should display..

Tue, 19 Mar 2013 10:27:29 GMT

HI ananth,

tryed but it is not showing correct data for remaining months

any help....