topic Re: Help in Change request in QlikView

Help in Change request

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

Please see the picture below. ”BolagNr” is he company code. Each company code is connected to specific “CO_Object”, each “CO_Object” contains the field “Funktion”. So for example when you choose company code 0240 only a few “CO_Object” will be selectable and therefore only the “Funktion ”s that belongs to those “CO_Object.

Economy uniper is final qvw and other one is qvw where transformation is taking place.

Can any one help me pls in this requirement ?? please its very urgent?

Thanks

Manu

Re: Help in Change request

ramasaisaksoft — Fri, 03 Nov 2017 08:51:56 GMT

Hi Sharma,

What is ur expected output?

Re: Help in Change request

manu1512 — Fri, 03 Nov 2017 09:03:26 GMT

Hi Rama,

Is there any way to filter out the values of Funktion from the table box after selecting values of company code and co_object?

Re: Help in Change request

manu1512 — Fri, 03 Nov 2017 10:58:27 GMT

stalwar1‌pradosh_thakur‌vishsaggi‌

Re: Help in Change request

vishsaggi — Fri, 03 Nov 2017 14:27:44 GMT

You cannot do much with the table box it is just used to display data. May be you want to use Straight table with some set analysis. If you can share some sample data we can look into it.

Re: Help in Change request

manu1512 — Fri, 03 Nov 2017 14:57:57 GMT

Hi Vish,

I have attached sample data ..Please suggest a solution

Re: Help in Change request

vishsaggi — Fri, 03 Nov 2017 15:03:59 GMT

Which table you want me to look and can you show me a screen shot of your selections and what you want to exclude?

Re: Help in Change request

vishsaggi — Fri, 03 Nov 2017 15:13:08 GMT

By the way the field you mentioned Funktion is not linked to your actual fact table may be you want to look at it.

The table name in your Table viewer is 8DOCOSTCENM.

Re: Help in Change request

manu1512 — Fri, 03 Nov 2017 15:20:59 GMT

Hi Vish,

I have attached the screenshot there of multibox in the original post.. will give you shore explanation:

if you go to Sydkraft tab in the multibox left of tab,

,After selecting any particular value in Funktion in multi box we should get values in Grey of Co_Object which are not connected to value selected in Funktion

I hope you got my requirement

Thanks

Re: Help in Change request

manu1512 — Fri, 03 Nov 2017 15:23:57 GMT

So can you please guide me what should i do from here.....?? to get this done

Re: Help in Change request

vishsaggi — Fri, 03 Nov 2017 15:30:13 GMT

First you need to figure out how the data from Funktrion is linked to your fact tables values. How do you know which value from Funktion is linked to values from Co_Object.

Re: Help in Change request

manu1512 — Fri, 03 Nov 2017 15:31:35 GMT

Okay Thanks Vish .... i will get back to you if i have more doubts......

Re: Help in Change request

vishsaggi — Fri, 03 Nov 2017 15:46:05 GMT

Sure let us know.

Re: Help in Change request

manu1512 — Wed, 06 Dec 2017 15:53:43 GMT

stalwar1‌ Can you please help

Re: Help in Change request

manu1512 — Wed, 06 Dec 2017 20:17:42 GMT

loveisfail‌pradosh_thakur‌shankarece‌isciberras‌ please help

Re: Help in Change request

Anil_Babu_Samineni — Thu, 07 Dec 2017 01:35:35 GMT

Hello Manu,

Can you help us to find out the sheet and field and result after filter from one - one ??

Re: Help in Change request

manu1512 — Thu, 07 Dec 2017 03:36:56 GMT

Hi Anil,

In qvw economy uniper apart from first and last sheet there is multibox .,... there I need to add funktion column

Such that when I select bolagnr in multibox ,only co objexkt belonging to selected bolagnr should reflect and after that only funktion belonging to co objexkt should reflect ......

Re: Help in Change request

manu1512 — Thu, 07 Dec 2017 07:30:50 GMT

loveisfail‌ any suggesstions pls?

Re: Help in Change request

Anil_Babu_Samineni — Thu, 07 Dec 2017 07:32:55 GMT

I don't have access your file now. I am in client space. So, Might others can help you or else will look by evening

Re: Help in Change request

Anil_Babu_Samineni — Thu, 07 Dec 2017 12:09:13 GMT

May be this?

If(GetFieldSelections(BolagNr)>0, 1,0)