Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I've a requirement where i have use dimension as a measure, but my that has string values so i can't use any aggr functions like sum, count exc. So currently am using Maxstring({<Category={"A"}>}OrderName) but the problem with this is when there are two records it 's only showing the largest string value because that's how this function works. But i need an expression which provides all possible values. Kindly help me here with correct formula.
Thanks in advance!
try to write if statement in script
if (category ="a",Ordename ) as AString
in chart you can count
You can use string aggregation functions with Aggr.
You want OrderName values only when associated with Category=A?
Aggr(Only({<Category={"A"}>}OrderName), OrderName)
BTW, I favor "Only" but Maxstring should work with the Aggr as well.
-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com