Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

Tags (2)
1 Solution

Accepted Solutions
MVP
MVP

Re: Logistic Question

Set Analysis should work, maybe like

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

in your calculated dimension,

=count({<ItemSpeed>}ItemId)

in the expression.

2 Replies
MVP
MVP

Re: Logistic Question

Set Analysis should work, maybe like

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

in your calculated dimension,

=count({<ItemSpeed>}ItemId)

in the expression.

Not applicable

Re: Logistic Question

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.

Community Browser