Inline Table Expression issue

pavanqlik — Thu, 10 May 2018 09:22:48 GMT

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:

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

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

Re: Inline Table Expression issue

vishalarote — Thu, 10 May 2018 10:47:07 GMT

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