Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aminqlik
Contributor
Contributor

Dimension limitations

Hi All:

  Raw data table as below:

DateTypeCount
1-JulA1
1-JulA1
1-JulB1
1-JulC1
1-JulE1
2-JulA1
3-JulB1
4-JulC1
5-JulA1
6-JulC1
7-JulD1

 

When I select date, it will show the types and total test count for each date.

Expected data out:

DateTypeTotal Test Count
3-JulB2

 

or 

DateTypeTotal Test Count
1-JulA4
2-JulB2
3-JulC3
4-JulE1

 

Thanks your help.

1 Solution

Accepted Solutions
Taoufiq_Zarra

Hi Amin,

one Solution

In dimension : Date and Type

and in expression :

=aggr(sum({1<Type=p(Type)>} Count),Type)

 

output :

Capture.PNG+

or

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

5 Replies
Taoufiq_Zarra

Can you develop more?

how you get for example :

4-JulE1
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
aminqlik
Contributor
Contributor
Author

Hi Taoufiq ZARRA:

   Sorry. Need to correct the second expected result.

   Should be:

   

DateTypeTotal Test Count
1-JulA4
1-JulB2
1-JulC3
1-JulE1

 

 

Taoufiq_Zarra

Hi Amin,

one Solution

In dimension : Date and Type

and in expression :

=aggr(sum({1<Type=p(Type)>} Count),Type)

 

output :

Capture.PNG+

or

Capture.PNG

 

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Kushal_Chawda

how you get  C for 3-Jul?

3-JulC3
aminqlik
Contributor
Contributor
Author

Hi Taoufiq ZARRA:

     Thank you so much for help. The problem has fixed by your suggestion.

Regards,

Shih Min