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...
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....
Please try to follow step-by-step.
and then go to qvw.
Might be you will get some idea about this raw file..
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...
Time god, Perfect..
But, When i select Oncology --> I want to highlight like Heamatology, Her 2, Avastin, Signalling
Find Image ..
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....
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.
Please attach me that Excel and qvw. SO that i can check and let you know...