Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yoganantha321
Creator II
Creator II

Triggers for two values

Hi all, 

I have a plan for the all the days in the month. 

In the below example, if i filter year as 2019 and month as Jan. It shows the list of persons in the Jan month but if i filter for Home as Chennai it is showing 3 persons as shown in below image:

community Home.JPG

But my expected output is if i select home it should also trigger travel_location and should show 4 persons who travel to chennai also.

 

I have attached the document along with this!!!

Anybody help me in this 

 

Regards,

Yoganantha Prakash G P

Labels (3)
1 Solution

Accepted Solutions
sunny_talwar

18 Replies
sunny_talwar

Like this?

image.png

yoganantha321
Creator II
Creator II
Author

Thanks Sunny,  

This is what i expected.

Also another requirement to show only 2 values for example Kasinath and Muthukumar in another chart or tab

sunny_talwar


@yoganantha321 wrote:

 

Also another requirement to show only 2 values for example Kasinath and Muthukumar in another chart or tab


What do you mean? Based on what conditions?

yoganantha321
Creator II
Creator II
Author

Sunny,

The colors differentiation is based on the type column.

Condition to show only 2 values means:

That the kasinath is on chennai homebase location and muthukumar travelling from another location say Koln to chennai.

So need to show only these two persons on another chart while filtering. Say example on clicking 17/01/2019 (today)

 

Thanks,

Yoganantha Prakash G P

sunny_talwar

So, I select 17-01-2019 and what else do I need to select?

yoganantha321
Creator II
Creator II
Author

Date column which contains all the dates in a year

yoganantha321
Creator II
Creator II
Author

Hi Sunny, 

Let me explain you clearly........

There is three parts travel,vacation,Homebase.

In calendar if i select 17/01/2019 and home base location as Chennai:

Usually displays 3 members belongs to chennai in which color differentiate it as homebase and Travel respectively. But my user requirement is if i select location Chennai and date as 17/01/2019, it should display Kasinath who is in homebase now and Muthukumar who travelled to Chennai from different location.

 

I have attached new qvw for reference.

Regards,

Yoganantha Prakash G P

sunny_talwar

What is wrong with Rahul? He seems to have Travel too...

image.png

yoganantha321
Creator II
Creator II
Author

But Rahul and Vasanth travels from Chennai to Koln on particular day say(17/01/2019).

But Kasi remain in chennai on that day and also Muthukumar comes to chennai on that day.