Need Week count

[soniasweety]

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)

[soniasweety]

No value it is giving sunny,

not working

[soniasweety]

and I have common fields also,,   but for one chart I am showing the count of both  ..   and  separate dashboards count showing also, that's y I used flag

[sunny_talwar]

What are you chart dimensions?

[soniasweety]

Item only.

[soniasweety]

Attaching sample

I am working on QLiksense

out put  is   count of item of max week is    :4

[sunny_talwar]

Which sheet are you using Sheet1 or Sheet2? and how did you get a count of 4?

[soniasweety]

sheet1 as  table1   sheet2 as table two

normal if I take count  of item in table1 for max week is 2  [max week is 30 ]

for second table is also 2  [max week is 30 ]

but I need in one chart count of item of both with max week

[sunny_talwar]

Since the Max(WeekNumber) is same in both the sheets, this should work

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

[soniasweety]

I will try with original data and let you know sunny.