Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Data retrieval based on priority... Help Me..Check the screen shot attached.

can any one help me , how to retrieve the data by priority vise in the expression.

Example: i hav the data

location,Area , customername, Capacity...four columns...

location
area
customercapacity
chennai

500
chennaisipcot
800
chennaisipcotAvula400

if my selection is chennai,sipcot,avula then the result set is 500,800 and 400.check the screen shot for refernce.

Attachments:

Tags (1)
4 Replies
MVP
MVP

Re: Data retrieval based on priority... Help Me..Check the screen shot attached.

Well, if you have selected chennai in field location, sipcot in field area and Avula in field customer, you should have limited the results to capacity 400 already.

I assume you want to retrieve the value for this line even without any selection in area and customer?

Not applicable

Re: Data retrieval based on priority... Help Me..Check the screen shot attached.

Exactly...i need that row alone...

MVP
MVP

Re: Data retrieval based on priority... Help Me..Check the screen shot attached.

Maybe like attached?

I created an additional ID field for the records using recno() in the LOAD script, the created a table chart with a calculated dimension:

=aggr(nodistinct if(rangesum(istext(area),istext(customer))=min(total<location> rangesum(IsText(area),istext(customer))), ID), location, ID)

You can hide all columns that you don't want to see.

Regards,

Stefan

Not applicable

Re: Data retrieval based on priority... Help Me..Check the screen shot attached.

Thank u,,

verymuch helpful....

Rgds,

Avula.gk

Community Browser