topic Re: Common Selection in QlikView

Common Selection

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have month field in common calendar and one field Plan_date in Other List box.

i want relation btwn those two fields if i will select the month then in plan_date should be select that particular month.

any help will be greatfull.

Thanks & Regards,

Qliker

Re: Common Selection

Anil_Babu_Samineni — Thu, 15 Sep 2016 07:06:18 GMT

Have you tried with Key

Load Rowno() as Key, Month from .....

Load Rowno() as Key, Plan_Date from ----

And then see, How DM visible?

Re: Common Selection

Thu, 15 Sep 2016 07:13:28 GMT

Demo,

I have two list boxes .

[Month]

jan

feb

march

apr

may

jun

.....

[Fiscal Month Year]

05-05-2016

08-06-2016

10-07-2016

20-08-2016

so i want if i will select the june from month list box then should be select 08-06-2016 from Fiscal month year list box.

Re: Common Selection

sasikanth — Thu, 15 Sep 2016 07:16:49 GMT

hi,

Please share a sample of your data

Re: Common Selection

pradeep_s — Thu, 15 Sep 2016 07:30:20 GMT

Hi Abhishek,

You have to create a link between those two through keys.

Alternately, you can also use triggers/Expressions(using variables) to achieve the same.

Thanks

Re: Common Selection

sasikanth — Fri, 16 Sep 2016 08:14:24 GMT

These two list boxes are from same table or Diffrnt tables?

Re: Common Selection

Anil_Babu_Samineni — Fri, 16 Sep 2016 08:45:36 GMT

Would you provide sample

Or, Try like this from your script

Original:

[Month]

jan

feb

march

apr

may

jun

LinkTable:

Month

Fiscal

Fiscal:

[Fiscal Month Year]

05-05-2016

08-06-2016

10-07-2016

20-08-2016

[Month]

jan

feb

march

apr

may

jun

.....

Month, [Fiscal Month Year]

May, 05-05-2016

Jun, 08-06-2016

Jul, 10-07-2016

Aug, 20-08-2016

Re: Common Selection

Anonymous — Fri, 16 Sep 2016 08:46:38 GMT

Hi,

If [Month] and [Fiscal Month Year] are in 2 separate tables, you could add this to the load script :

Load

[Fiscal Month Year],

Month(Date#([Fiscal Month Year],'DD-MM-YYYY')) as [Month],

....

This will convert the date into month, thus creating a link.