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

Table/data relationship

Dear community,

Attached herewith a sample document, anyone can help to solve this?

I want to find out the tier for corresponding channels, but how to show the tier number without including column Max and Min?

Thanks and best regards,

Chanel

1 Solution

Accepted Solutions
Not applicable
Author

Hi Chanel,


Does the attached solution work for you?

Rgds,

SK

View solution in original post

8 Replies
Not applicable
Author

Hi Chanel,


Does the attached solution work for you?

Rgds,

SK

er_mohit
Master II
Master II

See the attached file

Not applicable
Author

Thanks for prompt response!!

May i know why use Column(2)? what is column(2)?

if(Column(2)>0,sum(Spends))



Thanks and best regards,

Chanel

Not applicable
Author

Thanks for the reply, but i would like to have the final result as this:

Only 3 rows show the correct tier.

sk123456 has provided the correct result but not sure the column(2) is refer to which data and the purpose of it?

Thanks and best regards,

Chanel

Not applicable
Author

So column(2) is the second expression; the one where the Tier is calculated.

if(Column(2)>0, sum(Spends)) results in showing rows where Tier is a non-zero value.

Rgds,

SK


veidlburkhard
Creator III
Creator III

Hi Chanel,

what sk123456 is meaning is, that you should use your second expression to find your result.
You could as well take If(Tier > 0, sum(Spends)) This gives the same result.

Hope this helps

Burkhard

Not applicable
Author

Could you please help to solve how can i have only one row of "over" in Tier column?

Thanks,

Chanel

preminqlik
Specialist II
Specialist II

if([Min]>0,'Over',null())