Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MVP
MVP

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

Not applicable
Author

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
Specialist III
Specialist III

Dear ,

can you provide the sample data file.

tresesco
MVP
MVP

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

Not applicable
Author

Hi,


PFA, Sample File.

There is Customer Column, Value Column for Sales.

Not applicable
Author


I guess it would use an aggr() function