App Development

[Sxbbb]

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

[anthonyj · Accepted solution]

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]

thank you very much