Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Create rows - for each dimension

Hi !

I have this a table like this:

NameMin_YEARMax_YEAR
ABC20002002
CBA19992001
BCA20012002
BAC19992002

And I need to create like this:

NameYEAR
ABC2000
ABC2001
ABC2002
CBA1999
CBA2000
CBA2001
BCA2001
BCA2002
BAC1999
BAC2000
BAC2001
BAC2002

I was trying to use for each, but it didn't worked.

Tks a lot !

Tags (3)
1 Solution

Accepted Solutions
Gysbert_Wassenaar
Not applicable

Re: Create rows - for each dimension

See attached example


talk is cheap, supply exceeds demand
1 Reply
Gysbert_Wassenaar
Not applicable

Re: Create rows - for each dimension

See attached example


talk is cheap, supply exceeds demand