topic Re: Table with created dimensions in QlikView

Table with created dimensions

Wed, 25 Nov 2020 16:16:04 GMT

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?

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

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

Any suggestions?

Thank you.

Adrian E

Re: Table with created dimensions

vishsaggi — Thu, 10 Aug 2017 00:08:03 GMT

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

LOAD * INLINE [

Dim

];

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

)

Re: Table with created dimensions

Thu, 10 Aug 2017 00:40:41 GMT

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

];

In this, as Calculated Dimension?

Dim:

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

Thank you

Re: Table with created dimensions

techvarun — Thu, 10 Aug 2017 02:13:37 GMT

Try ValueList

valuelist and valueloop functions