Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a table in the following format like below.
SNO | Customer |
1 | Ramchander |
2 | Ushasree |
3 | Swetha |
Suppose if i click on the any of the customer like Ramchander or any another name, i need to see the details of the corresponding customer in a new QVW File in the following format
Customer name | Region | Target Amount | Due |
Ramchander | India | 100000 | 50000 |
Ushasree | USA | 200000 | 20000 |
Swetha | UK | 700000 | 70000 |
Any idea how to implement this.
Thanks,
Ram.
Ram,
Frankly, I don't understand why do you need "the new qvw file"... It is simpler to have all info in a single application. You select a Customer by clicking on the top table, and show details in the bottom table. If you wish, you can make the bottom table conditional, show it only if one Customer is selected.
Certainly you can do exactly what you asked - open new file for each customer. You will need to use INFO LOAD (BUNDLE LOAD), which will join (for the lack of a better word) each Customer with the appropriate qvw file. If you need example - see how the pictures joined with the names in the Presidents.qvw application.
Your true.With conditional load we can show the details in same the page. But in Business Objects we have a funtionality called as Hyperlink.That work as explained in my above mail.
Right i am showing the details as you explained.But the problem is i have 7 objects in my dashboard so user need to scroll down to the below. to see the details.That why i need to show them in separate QVW File.I cannot see the attachment.Can you please upload it again.
Thanks,
Ram.
You can get presidents.qvw file under C:/Programs Files/ Qlik view/Examples/Documents folder. or go to getting started page in the qlik view itself.
Thanks
Raghu.
Ram,
Raghu pointed out that the sample application was not the attachment. You have it and other examples if you did the Complete installation of QV.
Next, I don't think it's a good idea to replicate BO (or any other tool) behavior in QV. QV is more felxible than that, and allows to get the similar results with less efforts.
Third, if the problem is "not enough room" - create more tabs. And, implement behavior like this: on selecting of one Customer, switch automatically to another tab that has this Details table. There is no need to make things more complex than necessary.