Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all, I am new to QlikView. My dimensions are RefID, Product{A,B}, Action{Buy,Sell}
Thank you so much
Expressions to arrive at the numbers desired by you are in the attached qvw file.
There may be other solutions also.
Hope this helps.
Expressions to arrive at the numbers desired by you are in the attached qvw file.
There may be other solutions also.
Hope this helps.
thank you krishnamoorthy,
I have edited the expresson from Max({$<RefID={"1","2","3","4","5"}>} Price) to:
=Max ({$<RefID-={"STD"}>}Price)
in order to support user's selection.
I hope someone can tell me a method to merge those result chart tables into a one pivot table.
thanks