Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have created one inline table and used that to filter table data, based on selection. but output is not coming. i didn't understand why it is not
Inline Table:
Load * Inline [
Volumevscm
<{-30%}and>{30%}
<{-30%}and{10%}-{30%}
<{-30%}and{0%}-{10%}
<{-30%}and{-10%}-{0%}
<{-30%}and{-30%}-{-10%}
<{-30%}and<{-30%}
];
i have created one filter used above inline for filter the data of the table. in the table i wrote to below formula
i have created one inline table and used that to filter table data, based on selection. but output is not coming. i didn't understand why it is not
Inline Table:
Load * Inline [
Volumevscm
<{-30%}and>{30%}
<{-30%}and{10%}-{30%}
<{-30%}and{0%}-{10%}
<{-30%}and{-10%}-{0%}
<{-30%}and{-30%}-{-10%}
<{-30%}and<{-30%}
];
i have created one filter used above inline for filter the data of the table. in the table i wrote to below formula
=Pick(
Match(
GetFieldSelections(
[Volumevscm],
'<{-30%}and>{30%}',
'<{-30%}and{10%}-{30%}',
'<{-30%}and{0%}-{10%}',
'<{-30%}and{-10%}-{0%}',
'<{-30%}and{-30%}-{-10%}',
'<{-30%}and<{-30%}'
),
$(vc1), $(vc2),$(vc3),$(vc4),$(vc5),$(vc5),$(vc6)
)
variables formula in the pick match:
$(vc1)= aggr( if( $(vGrowthrateCm2) > $(vv1) and $(vGrowthrateVolume) < $(vv5), sold_to_desc ), sold_to_desc)
$(vc2)=aggr( if( $(vGrowthrateCm2) >= $(vv2) and $(vGrowthrateCm2) <= $(vv1) and $(vGrowthrateVolume) < $(vv5), sold_to_desc ), sold_to_desc )
$(vc3)= aggr(if($(vGrowthrateCm2) >= $(vv3) and $(vGrowthrateCm2) < $(vv2) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc)
$(vc4)=aggr(if($(vGrowthrateCm2) >= $(vv5) and $(vGrowthrateCm2) < $(vv4) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc)
$(vc5)=aggr(if($(vGrowthrateCm2) <= $(vv4) and $(vGrowthrateCm2) < $(vv2) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc)
$(vc6)= aggr(if($(vGrowthrateCm2) >= $(vv3) and $(vGrowthrateCm2) < $(vv2) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc).
my pick match formula is not giving output. showing '-' Kindly help me to solve the issue.
variables formula in the pick match:
$(vc1)= aggr( if( $(vGrowthrateCm2) > $(vv1) and $(vGrowthrateVolume) < $(vv5), sold_to_desc ), sold_to_desc)
$(vc2)=aggr( if( $(vGrowthrateCm2) >= $(vv2) and $(vGrowthrateCm2) <= $(vv1) and $(vGrowthrateVolume) < $(vv5), sold_to_desc ), sold_to_desc )
$(vc3)= aggr(if($(vGrowthrateCm2) >= $(vv3) and $(vGrowthrateCm2) < $(vv2) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc)
$(vc4)=aggr(if($(vGrowthrateCm2) >= $(vv5) and $(vGrowthrateCm2) < $(vv4) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc)
$(vc5)=aggr(if($(vGrowthrateCm2) <= $(vv4) and $(vGrowthrateCm2) < $(vv2) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc)
$(vc6)= aggr(if($(vGrowthrateCm2) >= $(vv3) and $(vGrowthrateCm2) < $(vv2) and $(vGrowthrateVolume)<($(vv5)),sold_to_desc),sold_to_desc).
my pick match formula is not giving output. showing '-' Kindly help me to solve the issue.
@Swathi , Can you check the definitions of each of your variables once. I think it must be an issue with the variable declaration that is not getting properly calculated while in the Pick statement. Can you send a screenshot of the Pick statement in the Expression editor, the whole screen would be helpful ,ie the grey part also where the evaluated expression is shown below..
Regards,
Rohan.
I am noticing that 12 is ⅓ of 36 and that your variables contain 2 commas each.
Could it be that the commas inside the variables get interpreted as separators in your pick statement. If that is true then the output should be off/wrong for all of your selections.
@Vegar, thanks for the reply, how to resolve that. i have sample file also
Hi @Swathi , I checked your qvf. The issue was with the variable definations as suspected. You had added comment in the variable declaration. It seems Qlik just fetches the whole string as is when calling the variable into your Pick() & that in turn is making your variables after $(vc13) as comment. Please refer the attached image :
Remove this comment & then your dashboard selections should work after 12 too.
Regards,
Rohan.