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

[krishna20]

Hi Anil,

PFA and let me know if its not your requirement.

[Anil_Babu_Samineni]

Kumar,

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

[krishna20]

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

[Anil_Babu_Samineni]

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

[krishna20]

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.

[Anil_Babu_Samineni]

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

[Anil_Babu_Samineni · Accepted solution]

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