topic Re: Dimension as measure in App Development

Dimension as measure

pgrs4219 — Tue, 21 Dec 2021 21:56:36 GMT

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!

Re: Dimension as measure

Channa — Fri, 09 Apr 2021 00:42:50 GMT

try to write if statement in script

if (category ="a",Ordename ) as AString

in chart you can count

Re: Dimension as measure

rwunderlich — Fri, 09 Apr 2021 04:02:06 GMT

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