topic Limit Months,weeks in QlikView

Limit Months,weeks

santhosh_k_n — Mon, 05 May 2014 04:50:38 GMT

Hi All,

I am using a cyclic group as a dimension in chart with 'Month,week and days' as sub dimensions.

Now i need to limit the dimensions as follows,

1. Months - for last 3 months

2. Weeks - to last 8 weeks

3. Days - as last 14 days

Irrespective of the from date and to date selected in the calender prompt.

Please guide

tresB — Mon, 05 May 2014 05:33:33 GMT

Try using expression in group like:

santhosh_k_n — Mon, 05 May 2014 06:05:50 GMT

hi Tresesco,

Thanks for your reply.

But I need to limit the week, days and month for the selected dates in the calender prompt

for eg: if from date is : 1st Apr and end date : 30- Apr,

then i need to display last 3 months: Jan,Feb and Mar

last 8 weeks: week 10 - week 18

last 14 days: 15th Apr - 29th Apr

tresB — Mon, 05 May 2014 06:07:21 GMT

Could you post your sample qvw?

santhosh_k_n — Mon, 05 May 2014 06:12:53 GMT

sorry i dont have a sample right now.

its_anandrjs — Mon, 05 May 2014 06:39:28 GMT

If possible provide some sample data in the excel file.