topic Help with syntax please :-) in QlikView

Help with syntax please :-)

Tue, 25 Jan 2011 12:26:02 GMT

HI All,

I have 2 dimensions - Week & Year in a pivot table

I am then trying to create an expression that counts the number of weeks in a month

i.e. It would show

2011 Week 1 - 4 (weeks in month)

2011 Week 2 - 4

2011 Week 3 - 4

2011 Week 4 - 4

2011 Week 5 - 5 (weeks in this month)

but cant get the correct combo of sum / total etc. right for the expression.

Any help would be appreciated please

Thanks

Bob

Tue, 25 Jan 2011 12:37:07 GMT

count( [Week])

If you want to creat a Month filter then you can use if or set analysis:

count( {<[Month] = {'whatyouwant'} >} [Week])

count( if ([Month] = 'whatyouwant', [Week]))

Tue, 25 Jan 2011 12:49:59 GMT

HI Jeres,

Thanks but that doesn't really work as it is counting a 3rd parameter. I literally just want to count the number of weeks in the month 😞

Any more thoughts please ?

Thanks

Bob