Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pavanqlik
Contributor II
Contributor II

Inline Table Expression issue

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 NameMeasures
M13
M212
M3-
M4-
M526

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

Metric NameMeasures
M13
M212
M3-
M426
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

1 Reply
vishalarote
Partner - Creator II
Partner - Creator II

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