Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I have straight table.It contains one dimension(A) and one expression(B)
I am looking for DROP DOWN selection for Expression(B).
Thanks
Gireesh
Does these are FAQ's? It's not possible for expression level. And this option available only for Dimension
Hi,
You can do it in Expression.
All you need to do is go to Expression. Select the Expression you want to group and click on the Group button below.
Regards,
Kaushik Solanki
Hi Kaushik Solanki,
I am asking DROP DOWN option not DRILL DOWN
Thanks
Gireesh
Hi Anil,
Any other option to enable DROP DOWN option in presentation tab?
I am using Concat(B,',') Expression in expression tab.
It is not working if i use Concat(B,',') expression in back end script or calculated dimension.
Thanks
Gireesh
We don't have the feature In Qlikview , we have the Grouping of expressions option .
If you want the drop down then try like this ..create an inline table with your expression name and in the front end add a list box or as a dimension and according to the selection made on the inline column enable your expression . This is the only you could get that representation
Hope this helps you
Not possible with expression, If expression can be used as calculated dimension than you can achieve this. But you have to check if the expression can be used as valid calculated dimension expression.
Hi kamal,
It is not working if i use Concat(B,',') expression in back end script or calculated dimension.
See this, Drop down select is not available for Amount in Expression but when I used that in Dimension I get drop down.
You can try this.
Refer attached QV doc.
Try once only with B, don't use concat.
Edit:
In the calculated dimension