topic Re: Grouping dimensions in Chart table in QlikView

Grouping dimensions in Chart table

markgraham123 — Mon, 22 Jun 2015 13:37:26 GMT

Hi,

I'm trying to group SKU, SUm(Units Packed), and Count(Locations) by Warehouse.

Aggr(Count(Distinct(SKU#)), [Warehouse])

Aggr(Sum([Units Packed]), [Warehouse])

Aggr(Count(LBCD), [Warehouse])

I'm not sure, whether this is right.

On the other hand, i'm trying to group SKU, SUm(Units Packed), and Count(Locations) by Warehouse

whose 360-day velocity Weeks on Hand is less than 8 and greater than 0.

If($(v360-day Velocity WOH)>=0 and $(v360-day Velocity WOH)<=8, Aggr(Count(DISTINCT(SKU#)), Warehouse))

If($(v360-day Velocity WOH)>=0 and $(v360-day Velocity WOH)<=8, Aggr(Sum([Sum of Units packed in recent 30 days]), Warehouse))

If($(v360-day Velocity WOH)>=0 and $(v360-day Velocity WOH)<=8, Aggr(Count(LBCD),Warehouse))

Please lemme knw the expressions accuracy.

Re: Grouping dimensions in Chart table

sunny_talwar — Mon, 22 Jun 2015 13:42:10 GMT

Is v360-day Velocity WOH a field name or is it a variable? It seems like a field to me, is that true?

Re: Grouping dimensions in Chart table

markgraham123 — Mon, 22 Jun 2015 13:43:55 GMT

Hi Sunny,

Its a variable.

v360-day Velocity WOH=(Sum([Qty On Hand])/([360-day Velocity]/52))

Re: Grouping dimensions in Chart table

sunny_talwar — Mon, 22 Jun 2015 13:54:45 GMT

Its difficult to imagine what you are trying to do before looking at an example? Do you have a sample we can look at?

Re: Grouping dimensions in Chart table

pratap6699 — Mon, 22 Jun 2015 13:57:21 GMT

by using aggr() is used for this requirement for group the column list,,it works like a group By clause in SQL

Re: Grouping dimensions in Chart table

markgraham123 — Mon, 22 Jun 2015 14:00:14 GMT

I'm trying to use the above conditions.

I wanna check with you guys, whether the condition syntax is fine.

Regarding the sample, its around 2 GB file and hence its difficult to upload.

Re: Grouping dimensions in Chart table

sunny_talwar — Mon, 22 Jun 2015 14:02:18 GMT

If the output you are getting is what you expect to see, I don't see a reason why you would think that the syntax is incorrect. Are you seeing any discrepancies in the results you are seeing? Make some filters and check it against your database to make sure that you are getting what you expect to see.

Best,

Sunny

Re: Grouping dimensions in Chart table

markgraham123 — Mon, 22 Jun 2015 15:39:18 GMT

Hi Sunny,

Can i please know the SET Analysis expression for the expresison:

If($(v360-day Velocity WOH)>=0 and $(v360-day Velocity WOH)<=8, Aggr(Count(DISTINCT(SKU#)), Warehouse))