topic Re: I need to display the first negative value date in App Development

I need to display the first negative value date

kirankumarsonoco — Mon, 17 Jan 2022 09:17:59 GMT

Hi Team,

I have 3 dimensions (Date, Plant, Item) and one Rangesum expression, Now i need to display the when rangesum value is negative, i want show the date of first negative value in Chart, Please anyone help me on this issue

Re: I need to display the first negative value date

vikasmahajan — Thu, 20 Jan 2022 10:12:51 GMT

You can use Firstsorted value for the same

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/AggregationFunctions/firstsorted.htm

Thanks

Vikas

Re: I need to display the first negative value date

kirankumarsonoco — Thu, 20 Jan 2022 12:46:17 GMT

I want to display in this chart level not script level, Please help me on this issue