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.
So my data looks like the below.
Article Time Field I want below
I need to create the equivalent of an array formula in excel (which led me to set analysis). Which returns the MAX time for a particular Article.
I am not sure how to write the set analysis or whether it is actually possible.
thus : MAX(IF(Article=Article,Time) (just a sample of the idea)
In more detail: I need the formula to evaluate each Article in the range to see if it matches the row Article and return the MAX Time.
Thanks in Advance ! Also, if not possible in the script, a front face solution will also be appreciated.
Ok so I would create a new table and join it back, hard to advise without table names etc but I can give you the basic syntax to use:
LOAD Article, Max(Time) as NewField
group by Article;
LEFT JOIN (yourtable)
LOAD * resident tmp;
drop table tmp;
I also had this solution, but the joining didnt work properly, I realised this was a result of bad formatting.
Thanks for the solution !
Pl close this issue by marking the correct answer if you like the solution given.
Another solution is applymap function.
Date(Max(Time),' hh:mm:ss') as MaxTime
Applymap('Max_Map',Article,0) as MaxTime
I did mark the answer as helpful, is there another way to mark it as correct?
Trust that you are doing great!
I agree with solutions of Adam & Eliza. BTW, as a front-end workaround you can add a calculated dimension with below definition.
Also refer the sample application attached herewith.
Hope this will be helpful.