value lists as second dimension based on the first dimension

[nishanthlm]

Hi All,

I am trying to create a value list based on another dimension and I am missing out something. Does any one have an idea on the below.

Load *

inline[

Time period 

MTD

YTD

FY]

I want to create a Vale list for each time period like below.

if(Timeperiod='MTD',valuelist('ACT','TGT','LF','PY'),

if(Timeperiod='YTD',valuelist('ACT','TGT','LF'),

if(Timeperiod='FY',valuelist ('ACT','TGT','LF','RR')))).

Expected output:

MTD	ACT
MTD	TGT
MTD	LF
MTD	PY
YTD	ACT
YTD	TGT
YTD	LF
FY	ACT
FY	TGT
FY	LF
FY	PY
FY	RR

Result

MTD	MTD
YTD	YTD
FY	FY

[marcus_sommer]

Why not just loading everything in the script, like:

Load * inline [Time period, ValueListValues

MTD	ACT
MTD	TGT
MTD	LF
MTD	PY
YTD	ACT
YTD	TGT
YTD	LF
FY	ACT
FY	TGT
FY	LF
FY	PY
FY	RR

] (txt, delimiter is \t);

- Marcus

[nishanthlm]

yes...That was what i used at first. I had issues with sorting them in order when using a Vizlib pivot table extension.

I figured it out eventually. It works now 🙂 

Thanks for the reply