topic Re: question in QlikView

question

userid128223 — Tue, 29 Sep 2015 17:17:08 GMT

From - PostalCode	From- City	To- PostalCode	To- City	Days
M1P	xyz	M1H	ppt	2
S1Q	yyz	M1H1KT	pps	5
T1P	tyz	P1T1QG	yts	4
M1H	abc	P1T	yms	1

Lets say i have above table. and i have selector for each field. How can i show chart that will do the following.

When user selects From Postal Code & City. Then picks To Postal Code it takes higher # of days at first 3 digit of To-Postal Code level.

Results Example

From - PostalCode	From- City	To- PostalCode	To- City	Days
M1P	xyz	M1H	pps	5

Re: question

sinanozdemir — Tue, 29 Sep 2015 18:22:39 GMT

Hi,

Let me know if this is something you are looking for:

I am attaching the qvw file as well.

Thanks

Re: question

userid128223 — Tue, 29 Sep 2015 19:51:36 GMT

yes. i don't see any solution.

Re: question

sinanozdemir — Tue, 29 Sep 2015 19:54:17 GMT

Can you explain why you don't see any solution?

Isn't the point to show the attributes of the postal code that has the highest days?

Re: question

Peter_Cammaert — Tue, 29 Sep 2015 22:20:14 GMT

Not entirely. I guess the request is somewhat different. Whenever a single From Postal code and/or From city is selected, the first three corresponding colums are displayed, together with To-city and Days from the row that has the same first three characters in To-PostalCode and the highest number of days. Not too simple.

Peter

Re: question

userid128223 — Wed, 30 Sep 2015 02:24:25 GMT

Thanks Peter. You have the understanding correct. Thx Sinan for an attempt.