topic Re: Conditional Intervals . How to deal , without using if ? in QlikView

Conditional Intervals . How to deal , without using if ?

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

Hi All ,

How to find data for conditional intervals , without using multiple if or hard coding as script level ?

In below data i want to populate values of table 2 , based on the value in Measure field of the table 1 .

Thanks & Regards

Shekar

Re: Conditional Intervals . How to deal , without using if ?

sunny_talwar — Fri, 04 May 2018 18:31:26 GMT

Should be Extended IntervalMatch

Re: Conditional Intervals . How to deal , without using if ?

felipedl — Fri, 04 May 2018 18:32:29 GMT

Hi SHekar,

Check the Intervalmatch function: https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptPrefixes/IntervalMatch.htm

It's exactly what it used for

Felipe.

Re: Conditional Intervals . How to deal , without using if ?

sunny_talwar — Fri, 04 May 2018 18:36:39 GMT

Try this

Vector_Observed_Temp:

CrossTable(Range, Data)

LOAD Vector_Observed,

[0 - 9],

[10 - 23],

[24 - 33],

[34 - 52],

[53 - 71],

[72 - 87],

[88 - 100]

FROM

[..\..\Downloads\Conditional Intervals.xlsx]

(ooxml, embedded labels, table is Vector_Observed);

Vector_Observed:

LOAD Vector_Observed as Vector,

SubField(Range, '-', 1) as Start,

SubField(Range, '-', 2) as End,

Data

Resident Vector_Observed_Temp;

DROP Table Vector_Observed_Temp;

MainTable:

LOAD Date,

Vector,

Measure

FROM

[..\..\Downloads\Conditional Intervals.xlsx]

(ooxml, embedded labels, table is Vector);

Left Join (MainTable)

IntervalMatch(Measure, Vector)

LOAD Start,

End,

Vector

Resident Vector_Observed;

Left Join (MainTable)

LOAD *

Resident Vector_Observed;

DROP Table Vector_Observed;

Re: Conditional Intervals . How to deal , without using if ?

shekhar_analyti — Fri, 04 May 2018 18:46:35 GMT

Thank You Bare Bhai ..