Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Table with created dimensions

    Hi,

Need to develop a straight table with dimensions I don't have in my data. I need the ones marked in yellow to be these dimensions(I don't have YYY, ZZZ, XXX, Growth as a Dimension in my data) Any suggestions?

Captura3.PNG

What I did was too painful, basically I created text boxes within a container like this

Captura4.PNG

This works but it gets really slow when you change any filter.

Any suggestions?

Thank you.

Adrian E

3 Replies
vishsaggi
Champion III
Champion III

You might want to use Pick and Match() using Island table. Like

LOAD * INLINE [

Dim

1

2

3

4

];

Your Regular Load Statements here..

Then in Straight table use like

Dim:

Pick(Match(Dim, 1, 2, 3, 4), 'XXX', 'YYY', 'ZZZ', 'Growth')

Expr:

Pick(Dim, Yourexprfor XXX,

                 YourExprfor YYY,

                 Yourexprfor ZZZ,

                 YourexprFor Growth

       )

Not applicable
Author

Thanks,

Couple of follow ups:

Here you refer to the ones marked in Blue (2016, YTD, FY, 18)? or Should I include also XXX, YYY, ZZZ, Growth?

LOAD * INLINE [

Dim

1

2

3

4

];

In this, as Calculated Dimension?

Dim:

Pick(Match(Dim, 1, 2, 3, 4), 'XXX', 'YYY', 'ZZZ', 'Growth')

Thank you

techvarun
Specialist II
Specialist II