topic Re: Need Help in QlikView

Need Help

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

Hello Experts,

I am very happy to post my issue here.

I have one Excel, in that --> All, Oncology, RA, Immunology

I have fields like Franchise Names, Product Names, Region Names, Month-Year(Jan to Sep), Fiscal Year(Three Quarters)

Please find Excel enclose and i share my QlikView Application also.

So, I want to show in qlikview like when i click on Franchise(Oncology) - I want to select like Product Names(For reference Goto Oncology sheet in Excel - Product Names are Heamatology, Her 2, Avastin, Signalling) and then when i click on Heamatology i want to show Regions like Region 1, Region 2, Region 3 Same as left products.

Note: How to arrange in Excel, I copy everything like below. PFA excel...

Re: Need Help

clondono — Fri, 20 May 2016 03:19:30 GMT

Hello Anil, I don't understand your question.

Re: Need Help

Anil_Babu_Samineni — Fri, 20 May 2016 03:23:11 GMT

Please try to follow step-by-step.

and then go to qvw.

Might be you will get some idea about this raw file..

Re: Need Help

Anonymous — Fri, 20 May 2016 05:14:40 GMT

Hello Anil,

I am not able to understand your question.

Re: Need Help

Anil_Babu_Samineni — Fri, 20 May 2016 05:28:53 GMT

Leela,

Did you saw the Excel?

If Yeah, Please go to the qvw and then check the Listboxes.

So, what i want to see here when i click on Specified Fanchisee i want to show associate of Franchisee (For reference goto Excel of Oncology tab - I mention over there, Those all are production Names. And then when i click on Production name i want to show associate region's. Like that...

I hope this explanation is good way...

Re: Need Help

krishna20 — Fri, 20 May 2016 06:44:00 GMT

Hi Anil,

Is this you are expecting???

Re: Need Help

Anonymous — Fri, 20 May 2016 06:53:38 GMT

Hi Anil Babu,

As krishna20‌ posted, is your requirement? or else what you are expecting let me know.

Re: Need Help

Anil_Babu_Samineni — Fri, 20 May 2016 07:13:13 GMT

Krishna,

Time god, Perfect..

But, When i select Oncology --> I want to highlight like Heamatology, Her 2, Avastin, Signalling

Find Image ..

Under Oncology

Heamatology -> Once i click that i want to show like Region 1, Region 2, Region

Her 2 --> Same as Heamatology

Avastin --> Same as Heamatology

Signalling --> Once i click on this, I dont want to show any regions. Because, There is no regions for this Product..

Same as RA and Immunology...!

and then Month-Year (MMM-YY) and then Quarter like Q1, Q2, Q3

Note: Final Conclusion is after that i want to show one graph which depends on this Data.

Please download my Excel and edit there only send me the Excel and QVW....

Re: Need Help

krishna20 — Fri, 20 May 2016 08:31:37 GMT

Hi Anil,

If i understand clearly. Is this your requirement??

When i select Oncology, the possible values in product Names should select dynamically??

If yes let me know.

Re: Need Help

Anil_Babu_Samineni — Fri, 20 May 2016 08:58:40 GMT

Please attach me that Excel and qvw. SO that i can check and let you know...

Re: Need Help

krishna20 — Fri, 20 May 2016 09:04:53 GMT

Hi Anil,

PFA and let me know if its not your requirement.

Re: Need Help

Anil_Babu_Samineni — Fri, 20 May 2016 09:14:23 GMT

Kumar,

Share me Excel also.. Because, This data takes from My Excel only...

Re: Need Help

krishna20 — Fri, 20 May 2016 09:15:56 GMT

I haven't do any changes in Ex-cel.

Re: Need Help

Anil_Babu_Samineni — Fri, 20 May 2016 10:31:22 GMT

Krishna,

Did you find any where in Current Selection. I didn't mention any thing specifically.. That is simple..

Why i am asking you, I don't want any functionality... I am fetching data from Excel only. I don't know how to arrange in excel.

I mention everything, Please find Qvw file...

If possible try to take own excel which similar to my field and do it....!

Hope this is final chance...

Re: Need Help

krishna20 — Fri, 20 May 2016 10:41:19 GMT

Hi Anil,

Go to Excel blog and post it there. You may get the right answer there. First of all we are not getting what is your requirement .. You are asking about to do us in Excel or in QVW file. ??

May someone helps you if they understood your requirement.

Re: Need Help

Anil_Babu_Samineni — Fri, 20 May 2016 10:45:57 GMT

Kumar,

Thanks for your patience..

Did you saw the 6th question. Can you please make one excel for me to get the same Output like 6th Question...

Re: Need Help

Anil_Babu_Samineni — Mon, 23 May 2016 06:49:42 GMT

I got the Solution.

I created different tables from Excel and then Combine to the Data model which is Primary key and Foreign key...

Thanks for all your support....