topic Re: Script Issue with MAX function in QlikView

Script Issue with MAX function

Wed, 17 Apr 2013 22:57:03 GMT

Hello all,

I'm new to Qlikview.

I have a situation like i got 100 million product details.

where productID will be unique but when ever the details changes we will have a new productdetailID.

I have to pick a latest one.

& My table have only ProductID & ProductDetailID fields.

when i'm using MAX function & grouping by ProductID.

I'm getting an invalid expression in script.

I tried MAXNUM which didn't worked.

Can anyone help me with this issue please.

thanks a lot to you all.

Re: Script Issue with MAX function

MayilVahanan — Wed, 17 Apr 2013 23:09:55 GMT

Try with FirstSortedValue() function

group by ProductID desc; // can able to use group by createdon desc;

hope it helps

Re: Script Issue with MAX function

Wed, 17 Apr 2013 23:13:31 GMT

Hi Mayil Vahanan,

Tried using firstsortedvalue(ProductdetailID,ProductID)

which gave me same error as

" Invalid Expression ".

tried max(productdetailID)

group by productID.

which gave me same error stating.

"Invalid Expression "

Re: Script Issue with MAX function

Thu, 18 Apr 2013 05:25:40 GMT

Hi ,

If ProductdetailID is a text.

Tried using MaxString() function.

As follows:

LOAD ProductID,

MaxString(ProductdetailID) as ProductdetailID

FROM

maxProduct.xlsx(ooxml, embedded labels, table is Sheet1)

group by ProductID;

hope it helps.

Re: Script Issue with MAX function

jagan — Thu, 18 Apr 2013 06:07:46 GMT

Hi,

Try like this in script

Products:

LOAD

WHERE IsLatestProduct = 1;

LOAD

ProductID,

ProductDetailID,

If(ProductID <> Previous(ProductID), 1, 0) AS IsLatestProduct

FROM DataSource

ORDER BY ProductID, ProductDetailID DESC;

Hope this helps you.

Regards,

Jagan.