Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

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

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

Yes.

Exactly.

markgraham123
Specialist
Specialist

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

Derz a Warehouse name OB2 mentione din the screenshot.

All the values correspond to that.