topic Re: value lists as second dimension based on the first dimension in App Development

value lists as second dimension based on the first dimension

nishanthlm — Sat, 16 Nov 2024 19:48:29 GMT

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:

Result

marcus_sommer — Mon, 28 Oct 2019 14:36:50 GMT

Why not just loading everything in the script, like:

Load * inline [Time period, ValueListValues

] (txt, delimiter is \t);

- Marcus

nishanthlm — Mon, 28 Oct 2019 19:18:12 GMT

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