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: 
markgraham123
Specialist
Specialist

Group by a dimension.

Hi,

I was trying to group the data w.r.t the dimension Warehouse.

When a warehouse is selected , intstead of seeing all the records with a total in a table.

I wanna see only the total of the data in the columns.

Please look at the atatchment - Table "0-8 WOH"

16 Replies
sunny_talwar

Can you reduce the size of the document?

markgraham123
Specialist
Specialist
Author

Hi Sunny,

I tried to. I was not able to reduce the size.

Here is the screenshot for your reference.

I was trying to have only one column, which shows the total sum of SKUs, pallets, and units.

Instead of many columns.

markgraham123
Specialist
Specialist
Author

If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8, Count(Distinct(SKU#)))

If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8,Sum([Units Packed]))

If((Sum([Qty On Hand])/([360-day Velocity]/52))>=0 and (Sum([Qty On Hand])/([360-day Velocity]/52))<=8, Aggr(Count(LBCD),SKU#))

These are the exp. used

sunny_talwar

Great and is this the part you are looking for?

Capture.PNG

and nothing below it, right?

markgraham123
Specialist
Specialist
Author

Yes.

Exactly.

markgraham123
Specialist
Specialist
Author

With a warehouse name.

sunny_talwar

Try this:

If(Dimensionality() = 0, YourExpressions) for all the three expressions and see if that does the trick for you.

Best,

Sunny

sunny_talwar

Which warehouse name?

markgraham123
Specialist
Specialist
Author

Derz a Warehouse name OB2 mentione din the screenshot.

All the values correspond to that.