Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
In given Qvw. I want to calculate Min & Max temp value on a range of load in text box.
Half Load :- Generator MW between (350 & 380)
Full Load :- Generator MW between (670 & 705)
In Case Load range not present in max date then it will show previous day value.
Try like:
=max({<[GENERATOR MW]={">=350<=380"}>}[MS LINE A TEMP]) & ' '
& FirstSortedValue({<[GENERATOR MW]={">=350<=380"}>} BLOCK,-[MS LINE A TEMP])&','&
Date(FirstSortedValue({<[GENERATOR MW]={">=350<=380"}>} LINKDATE,-[MS LINE A TEMP]) )
The rest you could adjust similarly by changing the range and max()/min().
Thanks a lot Tresesco,
It is working fine with date selection. But data should be show without any selection.
I did some changes in qvw by the help of that it is working fine.
I have one more scenario suppose on max of date (30-07-2018). i don't have Half load range(350-380) data.
In this case it should show last day data when Half load range was (350-380).