Between in Set Analysis

[rajkumarb]

Hi All

Please Suggest me how to use this below condition inside a set analysis

Below is the SQL Condition

where

(left(Productcode, 3) BETWEEN 'C00' AND 'D99')

[antoniotiman · Accepted solution]

Hi Raj,

try

Sum({<Product={"=Left(Product,3) >= 'C00' and Left(Product,3) <= 'D99'"}>} Value)

Regards,

Antonio

[tajmohamed30]

you can also use set analysis builder based on our requirement

Set Analysis Wizard for QlikView | qlikblog.at

[Anonymous]

yes, that will work