Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding a Dimension like a Qualifier/Grouper – Best way in script?

Hi! This is mi situation:

I have 3 Dimension (Especie, Variedad, CalibreStd. See table below). I need to add an extra dimension that Works like a qualifier/grouper of the CalibreStd dimension.

CalibreGrupo

Especie

Variedad

CalibreStd

1- 56-60

MANZ

ROGA

56

1- 56-60

MANZ

ROGA

60

2- 70-80

MANZ

ROGA

70

2- 70-80

MANZ

ROGA

80

3- 90-110

MANZ

ROGA

90

3- 90-110

MANZ

ROGA

100

3- 90-110

MANZ

ROGA

110

4- 120

MANZ

ROGA

120

5- 135

MANZ

ROGA

135

1- 56-60

MANZ

_default

56

1- 56-60

MANZ

_default

60

2- 70-80

MANZ

_default

70

2- 70-80

MANZ

_default

80

3- 90-110

MANZ

_default

90

3- 90-110

MANZ

_default

100

3- 90-110

MANZ

_default

110

4- 120+

MANZ

_default

120

4- 120+

MANZ

_default

135

1- 56-60

PERA

_default

56

1- 56-60

PERA

_default

60

2- 70-80

PERA

_default

70

2- 70-80

PERA

_default

80

3- 90-110

PERA

_default

90

3- 90-110

PERA

_default

100

3- 90-110

PERA

_default

110

4- 120+

PERA

_default

120

4- 120+

PERA

_default

135

The most practical way to maintain this data is specifying a default configuration (“_default”) for each Especie and specifying particular cases like Variedad=ROGA.

I need to know the best way to load this in script.

I thought add a key with 3 dimensions concatenation and use “ApplyMap” like this:

Key1->Especie|VariedadCom|CalibreStd

Key2->Especie|_default|CalibreStd

ApplyMap('MAPCalibreStdGrupo',Key1,Key2)

That’s works, but the problem is that if in the future the definition change (for example, adding a 4th or 5th dimension) this way is impossible to maintain.

So, how can I do that in the best way avoiding add ALL VALUES in the table. I need to avoid that because there are a lot of registriess and some dimensions grow dynamically and will be out of synch.

Thanks

2 Replies
sunny_talwar

What is the logic behind these ranges that can dynamically grow? If they follow a some kind of logic, we might be able to make it work

Not applicable
Author

Hi! There is no logic. It depends the season, because we are talking about fresh fruits (that every season change) and because some years some "Calibre" are more important than other and they need to change de grouping.