Discussion board where members can get started with QlikView.
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...
if my selection is chennai,sipcot,avula then the result set is 500,800 and 400.check the screen shot for refernce.
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?
Exactly...i need that row alone...
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.