Discussion Board for collaboration related to Creating Analytics for QlikView.
I am facing problem in set analysis for a expression.
I am attching one QVW file and one excel file, by which you can understand my problem.
Pls give me needfull sugestion.
Thanks in advance.
Go to Solution.
I changed something in the script to get the right data.
Altering ur second expression like this will get u the result
If i have not understood ur issue please let me know
I want to take comapny wise maximum month number....not max(monthno) of all garden.
In 2011 Company A has max(MonthNo)=6 val=160
In 2011 Company B has max(MonthNo)=9 val=250
Here maximum MonthNo is coming 9
i want to show 2010 record like this
In 2010 Company A has max(MonthNo)=6 val=210
In 2010 Company B has max(MonthNo)=9 val=290
By default selection ..... means clear all field.
Please see my excel sheet.
Thanks a lot halmar.
Nice job you have done.