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: 
Not applicable

Logistic Question

Hi, All.

I need your assistant in creating a complex chart.

In an automated logistic center, there is an important attention to the position of the product, in the warehouse, regarding where it positioned to the exit of the warehouse. these products are devide into 3 speed groups: 1,2,3 where 1 is the fastest to retrieve, thus the closest to the exit of the warehouse.

my (example) script:

set ItemID=Round(rand()*10000); //where ItemID is the ID of the product

set ItemSpeed=round(rand()*2)+1; //where ItemSpeed is the speed group of the product, thus the frequency it used.

load

$(ItemID) as ItemId,

$(ItemSpeed) as ItemSpeed

AutoGenerate(10000);

this gives me 10000 products (ItemID's) where each product has a speed (ItemSpeed).

there can be several products of the same ID (ItemID), i,e: 50 pencils of the same ID, and several speed to the same product. this can happend over time where the customer does not follows its own product speed group or the item/product frequncy (selling) in lower then expected.

a listbox of ItemID shows all products ID and the frequency.

in order to get frequency groups, i used aggr(count(ItemID),ItemID).

this give me a dimention (X axis) of 1 to 6.

the expression is count(ItemID).

i have created a listbox of the ItemSpeed, thus it shows 1,2,3.

when i select a frequency group, i.e 4, in the chart,

i get all product that have frequency of 4 in the listbox,

and the list box of ItemSpeed shows my all group speed.

thats fine.

but my problem is, that when i now select a specific speed group (that did shown in above), the calculation of the frequency group, i.e aggr..., changes to.

how can i prevent the recalculation of the frequency group (aggr...)?

i have tried with set analysis, same result - recalc.

attached is my example.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Set Analysis should work, maybe like

=aggr(count({<ItemSpeed>}ItemId),ItemId)

in your calculated dimension,

=count({<ItemSpeed>}ItemId)

in the expression.

View solution in original post

2 Replies
swuehl
MVP
MVP

Set Analysis should work, maybe like

=aggr(count({<ItemSpeed>}ItemId),ItemId)

in your calculated dimension,

=count({<ItemSpeed>}ItemId)

in the expression.

Not applicable
Author

Swuehl,

many thanks.

i didn't though of this approch.

sometimes the answer is under your nose.

i think this will solve my problem.

i will test it with the real data in my office at work where the data is stored in sql.

BR,

Moti.