Need Help

[Anil_Babu_Samineni]

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...

[clondono]

Hello Anil, I don't understand your question.

[Anil_Babu_Samineni]

Please try to follow step-by-step.

and then go to qvw.

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

[Anonymous]

Hello Anil,

I am not able to understand your question.

[Anil_Babu_Samineni]

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...

[krishna20]

Hi Anil,

Is this you are expecting???

[Anonymous]

Hi Anil Babu,

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

[Anil_Babu_Samineni]

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....

[krishna20]

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.

[Anil_Babu_Samineni]

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