Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
what is the variable expression? value please attach some sample file.