Changing of dimension values

[jacqueshol]

Hi all,

I have probably been abusing the good support of the Qlik community the past few days, but have been assisted wonderfully throughout.  So, after endlessly searching for an answer, I thought I'd try the community again for some answers.  Once again, I'm pretty sure that a simple solution exists, but as a newbie, it escapes me...

I have a number of CostTypes (>100), e.g. Salaries, Wages, Rent, Overtime, etc.  Each of these are classified as either a FIXED or VARIABLE cost.  I have set these in my input datasheet (Excel). E.g.

CostType	Classification
Salaries	Fixed
Wages	Fixed
Rent	Fixed
Overtime	Variable

However, there has been some debate among ourselves about the classification of some of these costs and I want to be able to change these classifications in QlikView, rather than in Excel and reloading the data every time.  Is this possible?  E.g. Wages has initially been categorised as a FIXED cost, but if we decide that it should be a VARIABLE cost, I'd like to make this change in the model so that it subsequently updates all my calculations based on FIXED and VARIABLE.  Am I making sense?

I've tried to use InputField, but my lack of knowledge has prevented me of coming up with a workable solution.

Any assistance would be greatly appreciated.

Take care,

Jacques

[jacqueshol]

Hi Kaushik,

Thank you for your willingness to assist.  Below I have inserted an image with a very simple database. You will notice that in the Detail Table, Rent is listed as a FIXED cost.  What I want to be able to do, for example, is to change that cost to VARIABLE.

 

Here is the amended datatable with the resultant changes in the Summary Table and Pie Chart. As you will notice the % splits has changed.  I did this in the source file (Excel).

I'd like to know if there is a way to do this in QlikView (by changing the Classification in my Detail Table), without having to go back to source.  We have a model that is reading millions lines of data and it is just not feasible to change it in source and reload it every time.  As mentioned before, I have tried my way around the InputField option, and even variables, but just couldn't get it to work.

Thank you again kindly for assisting me.

Take care,

Jacques

[jacqueshol]

Thanks Mark,

Unfortunately it isn't a calculated value (based on a value).  It is a subjective decision that is made on the fly by our management team as well as our customer's.  They review each cost and then debate whether it is a Fixed or Variable cost.  Most costs are easily determinable, but as you can imagine, that when you have 8 chartered accountants in a rooom, you are going to get at least 15 different opinions . That is why I want to be able to have a list of costs and perhaps a sort of dropdown box to select whether the cost is Fixed or Variable.  As the discussions continue, the guys may change their mind about a previous cost and I want to be able to change it quickly without having to reload which takes minutes each time.

Haha, it seems I stumped you all.  My boss is already telling me that this proves that Excel is a better tool.... *sigh*.  Really frustrating to see the potential of a tool, but not able to use it to its fullest...