Load two sets of Data on same QVD but two Dashboard
Hi everyone,
I have been doing a Qlikview Dashboard for the company. The company have got a Excel raw datafile. The datafile stored everyone sales record, distinguish by Market A, B and C.
Yesterday, they told me that they would like to add two more Market into business. Also, they want me to make two Dashboard, one showing only records in Market A, B, C , and the other showing the two new Market.
However, I have only got one single file, I have no idea that how to satify their need. Can anyone please help me?
PS: Apology for not showing the Excel File due to restrictions.
I do not believe you can write in the script to show data on a particular sheet. You would need to alter each expression. Use the Expression Viewer to help here.
On the other hand, you could copy the entire QVW and create a new one (so you'll have 2 now), then use Where clauses to bring in only markets A, B & C into one dashboard, and only markets D & E into the other.
On another hand, Alternate States might do it too, but you'd still need to update all associated objects. I haven't had the opportunity to use AS yet, so I'm not certain.
There are other ways to tackle this, such as adding a calculated field and using that to designate what to view where, but you'd still need to alter the expressions of one set of objects, or all.
Either way, IMO, a QlikView Developer cannot be lazy. I've had to update dozens of objects and one just needs to grind through it all. One thing this will do is get you thinking of better ways to set up a data model (to possibly allow for future expansion).
Are the new markets just appended to the existing data and just designated as D and E (example)?
If so, just create a new sheet, or copy the existing sheet so one sheet shows Markets A, B & C and call that Markets A, B & C, and the other sheet shows markets D & E and name it Markets D & E.
Then, change the expressions in one sheet to show just markets A, B & C and the other sheet expressions to show markets D & E. Set analysis is good at this...
The basic expression Sum(Value) will sum all the Value's (based on selection)
Sum({<Market={'A','B','C'}>}Value) will sum only markets A, B & C.
Sum({<Market={'D','E'}>}Value) will sum only Value's for markets D & E.
Thank you very much for your reply.Yep, let's call the two new Market D and E.
Set analysis would be one way to do it. But as there are quite a number of objects, say chart, listbox, etc. If I hard code for every formula in every object, that might be a little bit troublesome (ok I admit that I am extremely lazy).
Therefore I still want to ask, is there anyway to load somedata for one particular Dashboard, and load other data to another specified Dashboard, regarding two data are totally separated?
Any code I can type in so that Market A, B, C would only show up in Dashboard Number (for example SH01) and Market D, E would only show up in Dashboard Number (for example SH02)?
I do not believe you can write in the script to show data on a particular sheet. You would need to alter each expression. Use the Expression Viewer to help here.
On the other hand, you could copy the entire QVW and create a new one (so you'll have 2 now), then use Where clauses to bring in only markets A, B & C into one dashboard, and only markets D & E into the other.
On another hand, Alternate States might do it too, but you'd still need to update all associated objects. I haven't had the opportunity to use AS yet, so I'm not certain.
There are other ways to tackle this, such as adding a calculated field and using that to designate what to view where, but you'd still need to alter the expressions of one set of objects, or all.
Either way, IMO, a QlikView Developer cannot be lazy. I've had to update dozens of objects and one just needs to grind through it all. One thing this will do is get you thinking of better ways to set up a data model (to possibly allow for future expansion).
Please close this thread by answering Correct Answer or Helpful Answer to one of my suggestions. It helps others to find a similar question/answer. Thanks.
