topic Re: need to extract variable value for a particular date in QlikView

need to extract variable value for a particular date

Anonymous — Thu, 21 Sep 2017 06:02:15 GMT

I have an dimension called Last8WeeksReferencedateOpened.

I have variable value $(vAging_Incidents_weekly) that is displayed along the Y axis as expression.

For the max date I need to extract the value and display it in a text box.i.e. for 9/18/2017 I need to display in a text box value of 12.14

I have used formula of max(Last8WeeksReferencedateOpened) with only function but its not working..Can anybody please suggest?

Re: need to extract variable value for a particular date

tresB — Thu, 21 Sep 2017 06:07:21 GMT

Try like:

FirstSortedValue($(vAging_Incidents_weekly) ,- Last8WeeksReferencedateOpened)

Re: need to extract variable value for a particular date

Anil_Babu_Samineni — Thu, 21 Sep 2017 06:07:30 GMT

Is that Last8WeeksReferencedateOpened is the field? Will you able to provide sample?

Re: need to extract variable value for a particular date

Anonymous — Thu, 21 Sep 2017 06:09:49 GMT

I used firstsortedvalue and it shows blank value.

Re: need to extract variable value for a particular date

tresB — Thu, 21 Sep 2017 06:22:36 GMT

How is your variable defined? If there is any aggregation function like sum(), you might have to use aggr() too. Could you post your sample qvw?

Re: need to extract variable value for a particular date

Anonymous — Thu, 21 Sep 2017 06:37:19 GMT

I have attached my file. Please go to Sheet3.

In the script please refer to Reference Date for o/s and Aging for the field Last8WeeksReferencedateOpened .

Variable value is present in text file

Re: need to extract variable value for a particular date

tresB — Thu, 21 Sep 2017 07:05:48 GMT

I don't see any qvw file.

Re: need to extract variable value for a particular date

Anonymous — Thu, 21 Sep 2017 08:52:34 GMT

I used the aggr function and it worked. thanks for your suggestion it did help

=only({<Last8WeeksReferencedateOpened = {"$(=max(Last8WeeksReferencedateOpened))"}>}Aggr($(vAging_Incidents_weekly),Last8WeeksReferencedateOpened))