Calculated Dimension

[Anonymous]

Hi all,

My client requested to create a calulated dimension using the below query

select *  from db.TableName t

where (upper(XXX) = upper('value1') or

upper(XXX) = upper('value2'))

   and YYY<> 'value1'

   and ZZZ= 'value1'

Whether it is possible to create ??

Please help me.

Thanks

[Anonymous]

Actually I just started developing the application. So datamodel to show as of now.

In the requirement doc I have a table and in that I need to create a calculated dimension using the query I have shared.

So I am confused whether we could create a dimension using the query as it is mentioned like "Select *"

[kaushiknsolanki]

Hi,

   Understand one point in QlikView, first you write the script like Sql Statements and all and get the data in QlikView in table format. And once you have the data you can create charts by defining the dimensions and expressions

   Hope this is clear.

Regards,

Kaushik Solanki

[Anonymous]

Thanks Kaushik & mrdaan