Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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 (2)
1 Solution

Accepted Solutions
tresB
Champion III
Champion III

You are missing count WHAT ?

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

View solution in original post

4 Replies
tresB
Champion III
Champion III

Try like:

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

rolandg1881
Creator
Creator
Author

Hi!

Thank you!

Do i have the false Syntax?

 

rolandg1881_0-1587026785711.png

 

tresB
Champion III
Champion III

You are missing count WHAT ?

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

rolandg1881
Creator
Creator
Author

Ahhh!

Thank you!

 

😉