topic Re: Inline table help in QlikView

Inline table help

charlesdmeyer — Wed, 25 Nov 2020 16:16:04 GMT

I have a set of student data that has Test scores.

I want to create an inline table where any score below 20 is called Tier 3, 20 to 45 Tier 2 and 45 to 100 Tier 1.

I can't figure out how to put a formula like that in an inline.

So typically I would have something like,

[TestPercentile, Segment

<20, Tier 3

<34, Tier 2

etc.

];

Any help would be appreciated.

ychaitanya — Wed, 21 Mar 2018 15:02:03 GMT

Use an Interval Match Instead .

or use like this

LOAD * INLINE

[

Min_Score, Max_Score,Tier

0,20,Tier1

21,45,Tier2

46,100,Tier3

];

Digvijay_Singh — Wed, 21 Mar 2018 15:11:30 GMT

May be this -

Let i = 0;

For i = 1 to 100

Table1:

Load

Num($(i)) as Score,

if($(i)<20,'Tier 3',if($(i)<45,'Tier 2','Tier 1')) as Score_Level

AutoGenerate 1;

sasiparupudi1 — Thu, 22 Mar 2018 11:38:19 GMT

It is simple enough condition,I would suggest using an IF

If(TestPercentile<20,'Tier 3',If((TestPercentile>=20 AND TestPercentile<45),'Tier 2',If(TestPercentile>=45 AND TestPercentile<101,'Tier1'))) as Tier

Anonymous — Thu, 22 Mar 2018 15:24:06 GMT

I think it's better "Interval Match" this case.