topic Re: How to create silent legend dynamically in QlikView

How to create silent legend dynamically

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

Hi ,

I want to create silent legend for job types ( job type is a filter), that should be dynamic in nature. Lets say , I have date as filter and I have job type as filer (2 filters).

based on the date selection I get job types ( does not necessarily I will get all the job types, may be I will get 5 jobs out of 7)

Now I want to create silent legends for job type. Total I have 7 job types and I need to create 7 legends.

I am finding it difficult to create it dynamically so that I would show next to the list box .

I have searched in the community on how to create a silent legends but how do I create it such a way based on date selection it should

match (silent legend) with my job type.

Also , how do I confirm that after each reload my job type list box always show in the same order . If I understand correctly I need to create text boxes next to the list box.

Please advise.

Re: How to create silent legend dynamically

MarcoWedel — Sat, 06 Oct 2018 00:08:54 GMT

Hi,

maybe instead of creating separate text boxes next to your list box you could use a straight table e.g. like this:

hope this helps

regards

Marco

Re: How to create silent legend dynamically

ashis — Mon, 08 Oct 2018 05:02:36 GMT

Thank you very much Marco for you suggestion , I was looking something like this only.

Re: How to create silent legend dynamically

ashis — Mon, 08 Oct 2018 05:34:45 GMT

Hi Marco,

One quick question, like in list box we can select any value and then right click and do select excluded. So that our selected values would be excluded.

If I use straight table how do I get this exclusion done ?

Thank you,