Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Selecting a method to calculate the Dimension in a table.

Hi,

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.

Regards,

Pooja


6 Replies
tresesco
Not applicable

Re: Selecting a method to calculate the Dimension in a table.

May be like attached sample. Several ways could be there. I used conditional expression.

Not applicable

Re: Selecting a method to calculate the Dimension in a table.

Hi Treseco,

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.

Regards,

Pooja

mdmukramali
Not applicable

Re: Selecting a method to calculate the Dimension in a table.

Dear ,

can you provide the sample data file.

tresesco
Not applicable

Re: Selecting a method to calculate the Dimension in a table.

What would be the logic of customer based on average sales?

Not applicable

Re: Re: Selecting a method to calculate the Dimension in a table.

Hi,


PFA, Sample File.

There is Customer Column, Value Column for Sales.

Not applicable

Re: Re: Selecting a method to calculate the Dimension in a table.


I guess it would use an aggr() function