This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I facing an issue to know the value which has max count, let me explain you by example.
I can able to achieve the max count but I am facing an Issue finding the max cost value. Can you please let me know how can I achive this? Thank in advance.
How about this :
expression : FirstSortedValue(distinct Cost,-aggr( count(Cost),Month,Cost),1)
I tried this in my qvw, it works.
View solution in original post
May be this?
If you can accepted that adding some scripts in back-end, then I found a method, but I think it's not good, I'm trying to find another way.
LOAD * INLINE [
Count(Cost) as num
Group by Month,Cost;
LOAD Month,Cost,max(num) as num Resident T2 Group By Month,Cost;
DROP Table T2;
The expression : FirstSortedValue(distinct Cost,-num,1)
Thanks for your reply Anil. It is showing as below which is incorrect. Please find the attachement.
Thanks for your reply uacg0009As you said I need in Pivot table script it self. Adding another table will become performance Issue in our case.
Actually you can see my data model, I didn't add table, I just add one column finally.
But It will takes some times to make this column, so if your data is too large, it will affect your loading time I think.
If you can't accept this method, maybe I need to try to use another front-end way to make it.
Yes Aiolos, Table has some millions of data adding another field will cause performance. If we don't have any front end way then I can go with backend script.
You can see the attachment, using the expression like I said.
Seems like it is working, I will do further testing and let you know. Thank you uacg0009