topic Table/data relationship in QlikView

Table/data relationship

Mon, 10 Mar 2014 11:13:00 GMT

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

Re: Table/data relationship

Mon, 10 Mar 2014 11:36:37 GMT

Hi Chanel,

Does the attached solution work for you?

Rgds,

Re: Table/data relationship

er_mohit — Mon, 10 Mar 2014 11:40:07 GMT

See the attached file

Re: Table/data relationship

Mon, 10 Mar 2014 11:47:41 GMT

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

Re: Table/data relationship

Mon, 10 Mar 2014 11:52:38 GMT

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

Re: Table/data relationship

Mon, 10 Mar 2014 11:54:25 GMT

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,

Re: Table/data relationship

veidlburkhard — Mon, 10 Mar 2014 12:02:45 GMT

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

Re: Re: Table/data relationship

Mon, 10 Mar 2014 12:18:54 GMT

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

Thanks,

Chanel

Re: Table/data relationship

preminqlik — Mon, 10 Mar 2014 12:23:53 GMT

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