Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anil_Babu_Samineni

Need Help

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
1 Solution

Accepted Solutions
Anil_Babu_Samineni
Author

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 add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)

View solution in original post

16 Replies
clondono
Creator III
Creator III

Hello Anil, I don't understand your question.

Anil_Babu_Samineni
Author

Please try to follow step-by-step.

and then go to qvw.

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable

Hello Anil,

I am not able to understand your question.




Anil_Babu_Samineni
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
krishna20
Specialist II
Specialist II

Hi Anil,

Is this you are expecting???

comm.PNG

Anonymous
Not applicable

Hi Anil Babu,

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

Anil_Babu_Samineni
Author

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


Oncology.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
krishna20
Specialist II
Specialist II

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.

comm.PNG

Anil_Babu_Samineni
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)