topic Re: 9 weeks weekly data to be displayed in QlikView

9 weeks weekly data to be displayed

Mon, 29 Jul 2013 10:20:12 GMT

Hi,

I'm working on the trends to be displayed for 9 weeks data. This is the formula i've used for the calulation. But seems its not working. Can you please help me out of this issue.

Formula used :

sum({<CalYear=,Weekend=,[Month Year]=,date_con ={'>=$(=addmonths(min(date_con),-2))<=$(=max(date_con))'},[Metric_ID] ={'A_002'} >} Result

)/1000

Regards,

Archana.

Re: 9 weeks weekly data to be displayed

kaushiknsolanki — Mon, 29 Jul 2013 10:31:54 GMT

HI,

Archana try below code.

sum({<CalYear=,Weekend=,[Month Year]=,date_con ={'>=$(=addmonths(min(date_con),-2))<=$(=max(date_con))'},[Metric_ID] ={'A_002'} ,Month=,Year=,>} Result

)/1000

You must deselect the Date dimension when you are trying to get the data against the selection made.

So as shown in above expression kindly deselect the month and year selected.

Regards,

Kaushik Solanki

Re: 9 weeks weekly data to be displayed

Mon, 29 Jul 2013 10:37:43 GMT

Is data_con field in the same format as your default DateFormat?

eg 'YYYY-MM-DD'

Re: 9 weeks weekly data to be displayed

Mon, 29 Jul 2013 11:34:22 GMT

Hi alex,

The date format is DD-MM-YYY.

Re: 9 weeks weekly data to be displayed

Mon, 29 Jul 2013 11:39:00 GMT

Was i saying that field date_con must be in the default date format for your document.

Also if you post example file it wold be easyer to solv your problem.