Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

wolfgangmohr
New Contributor II

Weeks

Hi, good morning,

I am looking for a formula giving me the actual NUMBER OF WEEKS SELECTED into a Variable.

So take 2014, take May, you get 5 'White weeks' on your Calendar, and the number 5 should be used
for further calculations.

Take the weeks 18, 19 and 20 selected 'Green', the number 3 should be ..

Any idea?

Wolfgang

I just gave it into he Group 'Creating Analytics'

Tags (3)
1 Solution

Accepted Solutions
senpradip007
Valued Contributor III

Re: Weeks

Try this:

GetSeclectedCount(Week)

3 Replies
MVP
MVP

Re: Weeks

Count(WEEK) ?    Assuming you have a field called WEEK

senpradip007
Valued Contributor III

Re: Weeks

Try this:

GetSeclectedCount(Week)

wolfgangmohr
New Contributor II

Re: Weeks

Great, thank you!

Community Browser