topic Re: How to select a value from Calculated Dimension in QlikView

How to select a value from Calculated Dimension

Anonymous — Thu, 23 May 2013 20:37:13 GMT

Is there a way to select a calculated dimension value by clicking ? I have a staright table which have calculated dimensions with an If statement , and user wants to filter data by selecting a value in the Table , but this is not happening.

If I use the dimension out of table and use in a list box , that can be filtered . I see there is searchable option where they can type the exact value they want and then click enter to filter data ...but other than this option , can we do it by clicking ?

Thanks

Re: How to select a value from Calculated Dimension

swuehl — Thu, 23 May 2013 21:10:13 GMT

You should be able to make selections in a straight table, even on a calculated dimension.

Can you upload a small sample that demonstrate your issue?

Please note that you can only make selection in fields in your data model, so when clicking on a calculated dimension, you are actually selecting values in the fields that are involved in the calculated dimension.

Re: How to select a value from Calculated Dimension

Anonymous — Fri, 24 May 2013 15:03:18 GMT

ok one of my expression is maxstring(Date) ... and i am selecting a date with multiple records but only one record is selected , the one on which i am clicking.

Re: How to select a value from Calculated Dimension

Fri, 24 May 2013 15:08:27 GMT

Hi,

Ramya tell your problem with some more sample data ...............

Re: How to select a value from Calculated Dimension

calvindk — Fri, 24 May 2013 15:10:21 GMT

I am guessing that your underlying date is actually a timestamp. Change it to an actual datefield in the load, and it will work.

Re: How to select a value from Calculated Dimension

Anonymous — Fri, 24 May 2013 15:29:34 GMT

ok i moved one of my calculated dimension into script and brought that column as it is into table as dimension and now selection works , but maxstring(date) is actually an expression .. can selecting a value from expression filter the data?

if i move maxstring(date) to dimension i get error in calculated dimension message.