topic Re: Implement logic in qlik in QlikView

Implement logic in qlik

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

Hi,

I have a following sample data(given below) in which I have to implement a logic.

I want where cause damage tag=1 and also want to pick only one column (among material,outside labour,outside material and labour operation) where three values are # and under one column there is some value then that column needs to be picked in pivot table

like marked in red colour in below table. so how to write a calculated dimension

for eg:-

Material

Outside Material

Labour Operation

Outside Labour

Cause of Damage Tag

6R0937087ADZ0R

CONTR.UNIT

1500000

6R0937087ADZ0R

CONTR.UNIT

Not assigned

13621999

6R0959802EFZ05

WIND.MOT.

70591900

6R0959802EFZ05

WIND.MOT.

6R0959801EDZ05

WIND.MOT.

70591900

6R0959801EDZ05

WIND.MOT.

Re: Implement logic in qlik

Brett_Bleess — Mon, 06 Jan 2020 16:36:05 GMT

I would venture it is going to be difficult for anyone to help you unless you attach a sample app with some data and your data model etc.

The only other thing I can offer is the following:

https://community.qlik.com/t5/Qlik-Design-Blog/Calculated-Dimensions/ba-p/1472813

That may help you decide if calculated dimension is really what you want to do or if it would be better to use Set Analysis instead.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

If you wish to search the Design Blog area further on your own, use the following URL for that:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

There are hundreds of mostly how-to posts in that area from our experts, so would think you should be able to find some things to help you with this one if I have not hit on the right ones.

Regards,
Brett

Re: Implement logic in qlik

sakshikaul — Tue, 07 Jan 2020 03:45:08 GMT

Hi,

Data model contains a single fact table and final UI Application and raw sample data is also attached is as follows(screenshot attached):-

Here I want to apply a logic that when (refer raw data) cause damage type=1 and among material,outside material,labour operation and outside labour only one value will be considered and displayed under the marked column (marked in black color)

The value which needs to be considered depends upon the following for eg if cause of damage type=1 and under material value is 123456 , outside material #, labour operation is # and outside labour is # then in this case material will be picked and will be shown under column (circled in UI application (refer picture below)

simillarly eg-2 if cause of damage type=1 and under material value is # , outside material 12345, labour operation is # and outside labour is # then outside material column will be picked and value under outside material displayed in pivot chart (as shown below)

final UI application

Re: Implement logic in qlik

sakshikaul — Tue, 07 Jan 2020 04:38:51 GMT

Hi,

I have created following expression.

=if([Cause of Damage Tag]=1, if([Outside Labour]='#',if([Outside Material]='#',if([Labour Operation]='#',Material),
if([Outside Material]='#',if([Labour Operation]='#',if(Material='#',[Outside Labour]),
if([Outside Material]='#',if([Labour Operation]='#',if([Outside Labour]='#',[Labour Operation]),
if([Outside Labour]='#',if([Labour Operation]='#',if(Material='#',[Outside Material]))))))))))

Is it correct?