Creating a Single Dimension from Multiple fields

[Anonymous]

Hello All,

Can I create a single dimension from multiple fields in Qlikview?

Example:

Say I am having 3 fields in a table with name like SickLeave, CasualLeave, EarnedLeave.

Now I have to create a single dimension of these three fields say LeaveBalance.

Is it possible?

Regards,

Balraj

[ashfaq_haseeb]

Hi

You can try something like this

Table:

Load EMPID

sum(SickLeave)+sum(CasualLeave)+sum(EarnedLeave) as LeaveBalance

groupby EMPID;

Regards

ASHFAQ

[Anonymous]

Ya, it is possible.

But i could not get ur requirement.

Could you please explain with an ex?

[Anonymous]

Do you want to add the three fields as an expression or a dimension?

[#5]

Hi Balraj,

Where do you want to use this single dimension? Need more clear explanation or a sample qvw or an example.

Please provide.

[sibideepak]

HiBalraj Ahlawat

You can use cross table while loading data

Take 3 leave as measure & perform sum operation and Leave Balance as new dimension

Cross Table in Qlikview « Learn Qlikview

http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/24/crosstable

[Anonymous]

No,

I dont want to add these fields, I want to create a Dimension with these 3 fields and their Value.

Example:

LeaveBalance with three values SickLeave, CasualLeave, EarnedLeave with corresponding values.

Regards,

Balraj

[#8]

Can you please help me with sample data? So that we can get u a possible solution.

We understand that you want to have a column by name LeaveBalance and it should have the specified three values but where will you have the value for each one stored.

Do you want to achieve this will getting the data in the load script?

Provide with sample data.

[Anonymous]

Use Value List function to create the Dimension.

[MK_QSL]

Nothing clear from your question and explanation what exactly you want... Could you please provide little more clarification?