Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

markgraham123
Contributor II

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"

Tags (2)
16 Replies

Re: Group by a dimension.

Can you reduce the size of the document?

markgraham123
Contributor II

Re: Group by a dimension.

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
Contributor II

Re: Group by a dimension.

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

Re: Group by a dimension.

Great and is this the part you are looking for?

Capture.PNG

and nothing below it, right?

markgraham123
Contributor II

Re: Group by a dimension.

Yes.

Exactly.

markgraham123
Contributor II

Re: Group by a dimension.

With a warehouse name.

Re: Group by a dimension.

Try this:

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

Best,

Sunny

Re: Group by a dimension.

Which warehouse name?

markgraham123
Contributor II

Re: Group by a dimension.

Derz a Warehouse name OB2 mentione din the screenshot.

All the values correspond to that.

Community Browser