topic Dimension level if else condition help in QlikView

Dimension level if else condition help

ajaykumar1 — Tue, 23 Jun 2015 12:10:40 GMT

Hi Everyone,

I need some help to get the below requirement and the data is like below.

Input:

Part	OrderNo	OrderLineNo	CHARGETYPE	Cost
Samsung	88733	1		498
Melkco	88733	2		3
Other	88733	9000		0
	88733	1	SamsungDAC	-20
	88733		Frakt	5

Logic:

Based on the OrderNo and OrderLine No need to fill the blanks in Part field.So below sample output.

Part	OrderNo	OrderLineNo	CHARGETYPE	Cost
Samsung	88733	1		498
Melkco	88733	2		3
Other	88733	9000		0
Samsung	88733	1	SamsungDAC	-20
	88733		Frakt	5

Final Out Put :

When am selecting the samsung value in Part field then i need to get the below output.

Note : Here no need to consider the Chargetype is blank.So only -20.

Part	Cost
Samsung	-20

Note : I need to do this mainly in front end level only because of all the fields are coming multiple tables.So its very difficult to touch the data model.

Eagerly waiting for someone response to save my day 🙂

More Thanks,

Ajay

Re: Dimension level if else condition help

MK_QSL — Tue, 23 Jun 2015 12:17:24 GMT

It is difficult to get Part Samsung for same OrderLineNumber and OrderNo at front end. You can get the Name Samsung for Part field in script end.

Re: Dimension level if else condition help

ajaykumar1 — Tue, 23 Jun 2015 14:19:25 GMT

Thanks Manish.

I need to get this in front end itself.Anyway can you help me how to resolve this script level.

More Thanks,

Ajay

Re: Dimension level if else condition help

MK_QSL — Tue, 23 Jun 2015 14:27:12 GMT

FYI

Re: Dimension level if else condition help

antoniotiman — Tue, 23 Jun 2015 14:43:57 GMT

Hi,

try to use Calculated Dimension instead of Part

Aggr(MaxString(Part),OrderNo,OrderLineNo)

Regards,

Antonio

Re: Dimension level if else condition help

Kushal_Chawda — Tue, 23 Jun 2015 15:18:09 GMT

Hi,

I have done this in front end but not sure if this is good approach.

But for now it will help

Re: Dimension level if else condition help

ajaykumar1 — Tue, 23 Jun 2015 16:40:44 GMT

Thanks Manish...Its looks working fine through script.

Is it actually possible from front end?

More thanks,

Ajay

Re: Dimension level if else condition help

ajaykumar1 — Tue, 23 Jun 2015 18:20:28 GMT

Thanks Kush.But its not working.

If am selecting samsung in part level its showing 498 which is wrong....I want -20.

Thanks,

Ajay

Re: Dimension level if else condition help

Kushal_Chawda — Tue, 23 Jun 2015 18:24:44 GMT

Hi Ajay,

I have done some modification. Please check it out.

Re: Dimension level if else condition help

Kushal_Chawda — Tue, 23 Jun 2015 18:40:36 GMT

Hi Ajay,

I think best way to do it from front end is suggested by ANTONIO MANCINI with slightly changing the expresion

Re: Dimension level if else condition help

ajaykumar1 — Tue, 23 Jun 2015 19:06:27 GMT

Thanks Kush.

I will check your suggested solution and get back.

Regards,

Ajay

Re: Dimension level if else condition help

ajaykumar1 — Wed, 24 Jun 2015 05:45:26 GMT

Thanks Kush....But still getting the same problem.

I need to get -20 when am selecting the samsung value in field.

Regards,

Ajay

Re: Dimension level if else condition help

Kushal_Chawda — Wed, 24 Jun 2015 06:26:57 GMT

Hi Ajay,

Create calculated listbox and then select the value

you can select the Part value from New table itself which is created

Re: Dimension level if else condition help

ajaykumar1 — Wed, 24 Jun 2015 06:35:35 GMT

Hi Kush,

Could you please share the app if its possible.

More Thanks,

Ajay

Re: Dimension level if else condition help

Kushal_Chawda — Wed, 24 Jun 2015 07:02:49 GMT

Hi Ajay,

I have already attached app on above comment

Re: Dimension level if else condition help

antoniotiman — Wed, 24 Jun 2015 07:14:36 GMT

See attachment

Re: Dimension level if else condition help

ajaykumar1 — Wed, 24 Jun 2015 08:05:14 GMT

Hi Kush,

Please check your application with selection of 'samsung' in part field ...Its giving 498 which is not correct.

I want to show -20.

I hope my requirement is clear.

Re: Dimension level if else condition help

Kushal_Chawda — Wed, 24 Jun 2015 09:23:17 GMT

Please see the attached

Re: Dimension level if else condition help

ajaykumar1 — Wed, 24 Jun 2015 16:18:15 GMT

Thanks Kush..You saved some of my time.

Regards,

Ajay

Re: Dimension level if else condition help

jagan — Fri, 26 Jun 2015 06:55:33 GMT

Hi Ajay,

Handling this in script is better approach, Aggr() will have more performance issues if the data is huge that to you are using Calculated Dimension. Both it is not advisable to use.

Try to achieve this in script, it is the best solution.

Try below script

Data:

LOAD

AutoNumber(OrderNo & OrderLineNo) AS Key,

OrderNo,

OrderLineNo,

CHARGETYPE,

Cost

FROM

[https://community.qlik.com/thread/169557]

(html, codepage is 1252, embedded labels, table is @1);

Part:

LOAD DISTINCT

AutoNumber(OrderNo & OrderLineNo) AS Key,

Part

FROM

[https://community.qlik.com/thread/169557]

(html, codepage is 1252, embedded labels, table is @1)

WHERE Len(Trim(Part)) >0;