Discussion Board for collaboration on QlikView Scripting.
I am currently working on a requirement where the client wants to choose the method of calculating the the Dimension in the table dislplayed.
i.e. Min,Max or Average of Sales of a Client.
I need to provide a list box to the table having options of Min of Sales,Max of Sales or Average of Sales. Based on this selection the table list of clients should be calculated and displayed.
How does it work??
Your efforts are appriciated.
Thank You in Advance.
May be like attached sample. Several ways could be there. I used conditional expression.
Thanks for your reply.
I wanted a list of Customer's based on Max Sales, Min Sales or Average Sales.
Not Customer's Max, Min or Average Sales.
Can you please guide me.
Thank You in advance.
can you provide the sample data file.
What would be the logic of customer based on average sales?
PFA, Sample File.
There is Customer Column, Value Column for Sales.
I guess it would use an aggr() function