topic Re: Need Week count in QlikView

Need Week count

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to calculate the count of items of current week dynamically how to write the exp?

I have a weeknumber column in data

=count(Item)

Re: Need Week count

marcus_malinow — Wed, 06 Sep 2017 10:51:29 GMT

count({$<weeknumber={'$(=max(weeknumber))'}>} Item)

Re: Need Week count

Wed, 06 Sep 2017 10:51:44 GMT

Try this

Count({<weeknumber={$(=max(weeknumber))}>}Item)

Re: Need Week count

tresB — Wed, 06 Sep 2017 10:54:00 GMT

If your weeknumber field has values like, 1,2,... try like:

=Count({<weeknumber={'$(=Week(Today()))'}>}Item)

Re: Need Week count

florentina_doga — Wed, 06 Sep 2017 10:57:17 GMT

=count(distinct if(weekweeknumber)= week(today()),id_produs))

Re: Need Week count

its_anandrjs — Wed, 06 Sep 2017 10:58:12 GMT

Try with this expression

=count( {<weeknumber = {" $(=max( weeknumber ))"}>} Item)

Re: Need Week count

soniasweety — Wed, 06 Sep 2017 11:09:51 GMT

but,

in my data weeknumber based on data I need max of week based on data [I don't need based on calendar week]

for example: in my data maxweek is 30 so I need to show count of item of 30th week

weeknumber ---- this is not calendar week

Re: Need Week count

its_anandrjs — Wed, 06 Sep 2017 11:14:52 GMT

Let me know the field weeknumber is string field if not by this statement =max( weeknumber ) you get Max weeknumber that is 30 if they are number.

Re: Need Week count

soniasweety — Wed, 06 Sep 2017 11:18:05 GMT

yes,its number Anand,

in text object =max(weeknumber) showing 30.

in chart expression I have like this

Count({<Flag={1}>} Item)

I tried below

=count( {<Flag={1},WeekNumber = {" $(=max(WeekNumber))"}>} Item]) its not working

Re: Need Week count

sunny_talwar — Wed, 06 Sep 2017 11:20:47 GMT

May be you need to remove the additional square bracket around Item?

=Count({<Flag = {1}, WeekNumber = {" $(=max(WeekNumber))"}>} Item])

So, use it like this

=Count({<Flag = {1}, WeekNumber = {" $(=max(WeekNumber))"}>} Item)

Re: Need Week count

PrashantSangle — Wed, 06 Sep 2017 11:21:25 GMT

Hi there ] in your expression other wise your expression must work.

try after removing it.

Regards

Re: Need Week count

its_anandrjs — Wed, 06 Sep 2017 11:24:45 GMT

Your expression seems ok and working fine try some of this

=count( {<Flag={1},WeekNumber = {" $(=max(WeekNumber))"}>} Item)

=count( {<Flag={1},WeekNumber = {" $(=max(WeekNumber))"}>} [Item])

Re: Need Week count

soniasweety — Wed, 06 Sep 2017 11:33:18 GMT

Expression is showing Ok but if I write above the selection generated for this chart no data it is showing?

and I checked in text object it showing "0" and if I create a listbox for weeknumber and if I select 30th week that chart is showing values .

Re: Need Week count

sunny_talwar — Wed, 06 Sep 2017 11:37:11 GMT

What other selections are you making?

Re: Need Week count

its_anandrjs — Wed, 06 Sep 2017 11:37:33 GMT

In any straight table check this expression.

Re: Need Week count

PrashantSangle — Wed, 06 Sep 2017 11:41:40 GMT

debug your expression,

like take flag and WeekNumber as list box and take text object with simple expression count(Item)

or you can take Item as list box and check you have Item for respected selection.

Note : Field which you are using in set analysis is case sensitive.

Regards,

Re: Need Week count

soniasweety — Wed, 06 Sep 2017 11:43:41 GMT

sorry guys its working My bad there is spaces in the expression ,

I just copied from here and pasted it didn't worked, then I created new chart and typed the expression it given.

Thanks for your support

Re: Need Week count

soniasweety — Wed, 06 Sep 2017 12:37:58 GMT

One Quick question,

Sunny Talwar

I have two different tables that's why I created flag in the script ,

but in one chart I want to show both table count [this is also max week] and week column name is different how can I do?

Re: Need Week count

sunny_talwar — Wed, 06 Sep 2017 12:46:54 GMT

May be use Flag as one of the dimension and then use this:

=Count(Aggr(If(WeekNumber = Max(TOTAL <Flag> WeekNumber), Item), Flag, Item))

Re: Need Week count

its_anandrjs — Wed, 06 Sep 2017 12:53:14 GMT

Then use flag with different expressions because they are in different fields you have to use different expression either make changes in the data model and get this table into single table with table flag.