Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Implement logic in qlik


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:- 

Outside Material
Labour Operation
Outside Labour
Cause of Damage Tag
#Not assigned#13621999#1
3 Replies

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:

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.

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

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.


To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Creator II
Creator II


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 


Creator II
Creator II


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?