topic Re: Product Hiearchy get up level's name in QlikView

Product Hiearchy get up level's name

QSense — Sat, 16 Nov 2024 04:17:09 GMT

Hello ,

I have a case . There is an hiearchy table in my app . I would like write if statement in a straight table.

In my table below, I will add new calculate dimension.

My script like ;

At then end I would like to get this result (red one)

my script would like ; for ABC.1 row

if (one condition satisfies , match(up,level_explanation) ) // I dont know which function is used here.

I would like to get one up level's level explanation.

Thanks in advance.

kaushiknsolanki — Mon, 04 Mar 2019 12:47:41 GMT

Hi,

A small change in script will get you desired result with no hassle.

Try below script;

Data:

Load Level,UP,ID,Level_Explanation From XYZ;

Left join (Data)

Load ID as UP,Level_Explanation as UP_Level_Explanation From XYZ;

Regards,

Kaushik Solanki

Level

Level_Explanation

Shubham_Deshmukh — Mon, 04 Mar 2019 13:29:39 GMT

Use peek() in your script,

LOAD

myDate,

mySale,

if(condition,peek(mySale)) as expectedOutput
FROM --------