topic Re: Set analysis Sum Sales two days into one day in QlikView

Set analysis Sum Sales two days into one day

Peter_Brunner — Fri, 22 Mar 2013 06:34:25 GMT

Hi All,

I have been trying to add Saturdays sales into Mondays Sales but NOT show Saturdays sales Date on Graph. I have been using syntax below with

Mondays and Saturdays sales showing have tried several combinations but still no go. any help would be appreciated

if(Calendar_WeekDay ='Mon'or Calendar_WeekDay ='Sat' ,Sum({$<BusinessArea={[Building Supp]},Calendar_WeekDay={'Sat','Mon'}>}SalesValue))

regards Peter

Re: Set analysis Sum Sales two days into one day

kaushiknsolanki — Fri, 22 Mar 2013 06:45:01 GMT

Hi Peter,

I would recommend you to create a seperate field in Script which will show Monday in front of sunday and then use the field in chart to show the data.

Something like this.

Load if(wildmatch(Weekday(Date),'Sat*'),'Mon',Weekday(Date)) as New_WeekDay.

From xyz.

Regards,

Kaushik Solanki

Re: Set analysis Sum Sales two days into one day

somenathroy — Fri, 22 Mar 2013 06:52:55 GMT

Try with this:

if(Calendar_WeekDay ='mon'or Calendar_WeekDay ='sat' ,

Sum(TOTAL{<BusinessArea={[Building Supp]},Calendar_WeekDay={'sat','mon'}>}SalesValue),

sum(SalesValue))

Regards,

Som

Re: Set analysis Sum Sales two days into one day

Peter_Brunner — Mon, 25 Mar 2013 06:01:11 GMT

Hi Kaushik,

thanks for your help I did use it at script level but it still showed Saturdays I changed the dimension to a field to only show Selling Day Dates.

also thank you Som for your help

regards Peter

Re: Set analysis Sum Sales two days into one day

kaushiknsolanki — Mon, 25 Mar 2013 06:20:11 GMT

Hi,

Have a look at the attached example for more clarification.

Regards,

Kaushik Solanki

Re: Set analysis Sum Sales two days into one day

Peter_Brunner — Mon, 25 Mar 2013 06:50:01 GMT

Hi Kaushik,

first thank you for reply

Yes this works for the Days of the week.

I need it to be Date driven so I can show all selling dates for current month in graph.

if you select from your Dates list box the 2/3/2013 which is a Satuday and then select 4/3/2013

which is a Monday it does not add Satudays total to Mondays but if you do via weekdays it does

Peter

Re: Set analysis Sum Sales two days into one day

kaushiknsolanki — Mon, 25 Mar 2013 06:54:57 GMT

Dear Peter,

If you select the dated then you will not be able to see the bar chart.

Will you please tell us why you want to have this on date selection basis? when you can have that on weekday basis.

Regards,

Kaushik Solanki

Re: Set analysis Sum Sales two days into one day

Peter_Brunner — Tue, 26 Mar 2013 06:50:57 GMT

Hi Kaushik,

sorry for late reply, and thank you for your help.

The reason I need dates is the Sales graph I am doing is by Month and I need to show all the working days or "Dates" in graph.

Sorry it is my fault I did not explain it properly, but I have it working now.

Best regards Peter