Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

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)
Tags (2)
1 Solution

Accepted Solutions

Re: Need Help

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

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
Contributor III

Re: Need Help

Hello Anil, I don't understand your question.

Re: Need Help

Please try to follow step-by-step.

and then go to qvw.

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

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)
leelamadhav
Contributor

Re: Need Help

Hello Anil,

I am not able to understand your question.




Re: Need Help

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

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)
Highlighted
krishna20
Valued Contributor II

Re: Need Help

Hi Anil,

Is this you are expecting???

comm.PNG

leelamadhav
Contributor

Re: Need Help

Hi Anil Babu,

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

Re: Need Help

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

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
Valued Contributor II

Re: Need Help

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

Re: Need Help

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

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)