topic Re: set analysis in QlikView

set analysis

Thu, 29 Jan 2015 14:04:28 GMT

i have data in table like below

table1

total sno

10 1

12 2

6 3

table2

in want to use set analysis

count( {<total={'>=10'} , total= {'>=if(isnull(price1)=-1,0,price1) + if(isnull(price2)=-1,0,price2)'} >} sno)

is this expression possible>???? for me giving empty chart

Thu, 29 Jan 2015 14:06:10 GMT

In actual scenario i have some records which are total > price1+price2

ashwanin — Wed, 04 Feb 2015 10:14:30 GMT

Please tell, what actual you required in output .

avinashelite — Wed, 04 Feb 2015 10:17:12 GMT

try like this:

it will work but it should be double quots "" not the single quots ''

count( {<total={">=10"} , total= {">=if(isnull(price1)=-1,0,price1) + if(isnull(price2)=-1,0,price2)"} >} sno)