Need DROP DOWN selection for Expression

[gireesh1216]

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

[Anil_Babu_Samineni]

Does these are FAQ's? It's not possible for expression level. And this option available only for Dimension

[kaushiknsolanki]

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

[gireesh1216]

Hi Kaushik Solanki,

I am asking DROP DOWN option not DRILL DOWN

Thanks

Gireesh

[gireesh1216]

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

[avinashelite]

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

[kamal_sanguri]

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.

[gireesh1216]

Hi kamal,

It is not working if i use Concat(B,',') expression in back end script or calculated dimension.

[kamal_sanguri]

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.

[kamal_sanguri]

Try once only with B, don't use concat.

Edit:

In the calculated dimension