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: 
userid128223
Creator
Creator

question

From - PostalCodeFrom- CityTo- PostalCodeTo- CityDays
M1PxyzM1Hppt2
S1QyyzM1H1KTpps5
T1PtyzP1T1QGyts4
M1HabcP1Tyms1

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 - PostalCodeFrom- CityTo- PostalCodeTo- CityDays
M1PxyzM1Hpps5
5 Replies
sinanozdemir
Specialist III
Specialist III

Hi,

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

Capture.PNG

Capture.PNG

I am attaching the qvw file as well.

Thanks

userid128223
Creator
Creator
Author

yes. i don't see any solution.

sinanozdemir
Specialist III
Specialist III

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?

Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

userid128223
Creator
Creator
Author

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