Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I want all values ​​to be displayed in the table.

Suchanan_0-1671074556060.png

I want the value 247 out of every cell in the table.
like this

Suchanan_1-1671074688189.png

 

used code

Suchanan_2-1671074736612.png

 

I've tried this code.

Suchanan_3-1671074802453.png

 

but not desirable.
I want like this

Suchanan_4-1671074865431.png

 

 
1 Solution

Accepted Solutions
anthonyj
Creator III
Creator III

Hi @Sxbbb ,

It looks like a pivot table you're using so you want the TOTAL function to aggregate by the date. You've also got an Aggr( ) function that's turning your measure back into a dimension. If you can start with the measure try:

count(total <Output_Date> {$<OP_WorkCenter={'DES'}>} Production_No)

The total tells Qlik to ignore all the dimensions except the value between the angle brackets.

I hope this helps.

View solution in original post

2 Replies
anthonyj
Creator III
Creator III

Hi @Sxbbb ,

It looks like a pivot table you're using so you want the TOTAL function to aggregate by the date. You've also got an Aggr( ) function that's turning your measure back into a dimension. If you can start with the measure try:

count(total <Output_Date> {$<OP_WorkCenter={'DES'}>} Production_No)

The total tells Qlik to ignore all the dimensions except the value between the angle brackets.

I hope this helps.

Sxbbb
Creator III
Creator III
Author

thank you very much