topic I want all values to be displayed in the table. in App Development

I want all values to be displayed in the table.

Sxbbb — Thu, 15 Dec 2022 03:28:45 GMT

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

like this

used code

I've tried this code.

but not desirable.

I want like this

Re: I want all values to be displayed in the table.

anthonyj — Thu, 15 Dec 2022 05:14:27 GMT

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.

Re: I want all values to be displayed in the table.

Sxbbb — Thu, 15 Dec 2022 06:03:29 GMT

thank you very much

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

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

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

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

topic I want all values to be displayed in the table. in App Development

I want all values to be displayed in the table.

Re: I want all values to be displayed in the table.

Re: I want all values to be displayed in the table.