topic Triggers for two values in QlikView

Triggers for two values

yoganantha321 — Sat, 16 Nov 2024 21:35:20 GMT

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:

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

Re: Triggers for two values

sunny_talwar — Thu, 17 Jan 2019 12:26:48 GMT

Like this?

Re: Triggers for two values

yoganantha321 — Thu, 17 Jan 2019 12:31:23 GMT

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

Re: Triggers for two values

sunny_talwar — Thu, 17 Jan 2019 12:32:42 GMT

@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?

Re: Triggers for two values

yoganantha321 — Thu, 17 Jan 2019 12:42:59 GMT

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

Re: Triggers for two values

sunny_talwar — Thu, 17 Jan 2019 12:59:31 GMT

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

Re: Triggers for two values

yoganantha321 — Fri, 18 Jan 2019 04:59:15 GMT

Date column which contains all the dates in a year

Re: Triggers for two values

yoganantha321 — Wed, 30 Jan 2019 13:40:15 GMT

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

Re: Triggers for two values

sunny_talwar — Fri, 18 Jan 2019 12:30:01 GMT

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

Re: Triggers for two values

yoganantha321 — Fri, 18 Jan 2019 13:25:08 GMT

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.

Re: Triggers for two values

sunny_talwar — Fri, 18 Jan 2019 13:30:52 GMT

Check attached

Re: Triggers for two values

yoganantha321 — Fri, 18 Jan 2019 13:35:45 GMT

It was partial output Sunny, because if we clear the filtering say select the whole month some dates showing blank

Re: Triggers for two values

sunny_talwar — Fri, 18 Jan 2019 13:43:25 GMT

I guess I don't understand your data and output requirement as well as you do..... when you asked me to get it working for a single day... that is what I did... I won't really know why it doesn't work when you clear out selections. If you can tell me what is the required output when nothing is selected, I might be able to look at it.

Re: Triggers for two values

yoganantha321 — Wed, 30 Jan 2019 13:42:12 GMT

My required output is as shown in the below image

If i select the filters the output given previous qvw given by you.

Thanks

Re: Triggers for two values

sunny_talwar — Fri, 18 Jan 2019 13:56:35 GMT

I am not 100% certain, I understand this well, but if you already have a working solution, then why are we trying to do this again?

Re: Triggers for two values

yoganantha321 — Fri, 18 Jan 2019 13:59:50 GMT

But when we selecting the filter of home location i need the requirement as the solution previously given by you

Re: Triggers for two values

sunny_talwar — Fri, 18 Jan 2019 14:03:44 GMT

I hope this will work for you

Re: Triggers for two values

yoganantha321 — Fri, 18 Jan 2019 14:08:11 GMT

Thanks Sunny.

This is what i expected output.

Sorry for not giving correct input and Thanks for big support.

Regards,

Yoganantha Prakash G P

Re: Triggers for two values

sunny_talwar — Fri, 18 Jan 2019 14:10:18 GMT

No problem at all. I am glad we finally managed to get it resolved.