Inline Table Expression issue

[pavanqlik]

Hi Team,

  I had created  inline table with 5 dimensions.

Table:

LOAD * Inline [

SNo,MetricName

1,'M1'

2,'M2'

3,'M3'

4,'M4'

5,'M5'

];

Each metric has expression where i had added expression in 5 different variables.

My Problem: I am creating a straight table with metric name as dimension and expression using if condition.

    My expression looks like this:   =pick(WildMatch(SNo,1,2,3,4,5),$(v1),$(v2),$(v3),$(v4),$(v5))

So my output looks like this when i select filters

Original output i need to get:   

Metric Name	Measures
M1	3
M2	12
M3	-
M4	-
M5	26

But i am getting as below in Qlikview which is wrong.

Metric Name	Measures
M1	3
M2	12
M3	-
M4	26
M5	-

In the above picture M3 and M4 has null but in Qlikview in M4 i am getting M5 value.

Could you please help me on this.

Thanks,

Pavan

Message was edited by: Pavan Kumar

[vishalarote]

what is the variable expression? value please attach some sample file.