Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
rolandg1881
Creator
Creator

Count Question

 Hi!

Hope your are all healthy!

I've one Question to the follwing table.

You can see, i need a count with this Options:

The Person "GRUMET" has for exapmle worked on 4 Projects at 08.01.2020  and 2 Projects on 07.01.2020.

I need a count column where the count is next to every 08.01.2020 = 4 and next to 07.01.2020 = 2 etc.

I think its anything with sum(aggr(count... but i dont know the true code 

Has anybody an idea how i can realise this?

rolandg1881_0-1587023769785.png

Thank you very much!

Greetings

Labels (1)
  • Count

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You are missing count WHAT ?

Count ( Total  <Mitarbeiter, [Datum Meldung]> YourFieldToBeCounted )

View solution in original post

4 Replies
tresesco
MVP
MVP

Try like:

Count ( Total  <Mitarbeiter, [Datum Meldung]> ...

rolandg1881
Creator
Creator
Author

Hi!

Thank you!

Do i have the false Syntax?

 

rolandg1881_0-1587026785711.png

 

tresesco
MVP
MVP

You are missing count WHAT ?

Count ( Total  <Mitarbeiter, [Datum Meldung]> YourFieldToBeCounted )

rolandg1881
Creator
Creator
Author

Ahhh!

Thank you!

 

😉