Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have data as below snapshot, i need expression to show amount 1234 without hampering other fields and number of rows. I tried using aggr by NEW PRCTR but its not working.
Please help!!
Hi @sheetal1234, I think you are asking for First() or Top() function, depending if you are using a straight or pivot table. More information here: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/... and here: https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...
JG