topic Re: Specific Field Value Issue in QlikView

Specific Field Value Issue

Anonymous — Fri, 09 Oct 2015 10:15:38 GMT

Hello All,

I have an issue where I want to get specific field value for my chart.

Example

I have a chart with Dimension as Year and Year I want 4 measures each with value of ECO Actual Duration where its Row number will be from the Output Format Sheet (its and example) i.e. 25, 50,75 ,100% Row Value

Please find the attached file for sample data

Re: Specific Field Value Issue

robert_mika — Fri, 09 Oct 2015 10:20:04 GMT

Like this?

CrossTable(COUNT, Data)

LOAD YEAR,

COUNT,

[25% Row Val],

[50% Row Val],

[75% Row Val],

[100 % Row val]

FROM

(ooxml, embedded labels, table is [OUTPUT Format]);

Re: Specific Field Value Issue

Anonymous — Fri, 09 Oct 2015 10:25:04 GMT

Hi Robert ,

Thanks for Reply,

BUt think I was unable to ellaborate my requirement.

Actually I need to create 4 expression

for 25% Row Val >> the value should be the value of ECO Actual Duration at 91 st row for 2013, 184th row for 2014 and 1675th value for 2015.

An so on..