topic How would I write Set expression for different criterias? in QlikView https://community.qlik.com/t5/QlikView/How-would-I-write-Set-expression-for-different-criterias/m-p/268876#M1187399 <HTML><HEAD></HEAD><BODY><P>On what do you need Set Analysis? Set analysis is analogus to WHERE in SQL.</P><P></P><P>Regards,</P><P>Kiran</P></BODY></HTML> Fri, 16 Sep 2011 19:37:48 GMT 2011-09-16T19:37:48Z How would I write Set expression for different criterias? https://community.qlik.com/t5/QlikView/How-would-I-write-Set-expression-for-different-criterias/m-p/268875#M1187398 <HTML><HEAD></HEAD><BODY><P>My formula is below, how would I write Set expression?</P><P></P><P>=((table1 expession/table2 expression)*1000*(#ofdays in year))/#ofdays in month field1</P></BODY></HTML> Fri, 16 Sep 2011 17:50:46 GMT https://community.qlik.com/t5/QlikView/How-would-I-write-Set-expression-for-different-criterias/m-p/268875#M1187398 2011-09-16T17:50:46Z How would I write Set expression for different criterias? https://community.qlik.com/t5/QlikView/How-would-I-write-Set-expression-for-different-criterias/m-p/268876#M1187399 <HTML><HEAD></HEAD><BODY><P>On what do you need Set Analysis? Set analysis is analogus to WHERE in SQL.</P><P></P><P>Regards,</P><P>Kiran</P></BODY></HTML> Fri, 16 Sep 2011 19:37:48 GMT https://community.qlik.com/t5/QlikView/How-would-I-write-Set-expression-for-different-criterias/m-p/268876#M1187399 2011-09-16T19:37:48Z How would I write Set expression for different criterias? https://community.qlik.com/t5/QlikView/How-would-I-write-Set-expression-for-different-criterias/m-p/268877#M1187400 <HTML><HEAD></HEAD><BODY><P>I'm filtering my variables in my expression in my pivot table.&nbsp; I read that Set analysis was most efficient way to calculate.&nbsp; I'm not sure how to write my formula using Set analysis syntax.</P></BODY></HTML> Fri, 16 Sep 2011 20:48:28 GMT https://community.qlik.com/t5/QlikView/How-would-I-write-Set-expression-for-different-criterias/m-p/268877#M1187400 2011-09-16T20:48:28Z How would I write Set expression for different criterias? https://community.qlik.com/t5/QlikView/How-would-I-write-Set-expression-for-different-criterias/m-p/268878#M1187401 <HTML><HEAD></HEAD><BODY><P><EM>Hi,</EM></P><P></P><P><EM>Please can you post the sample QV App. with your original expression? Also, it will be good to give more details on what you wanted to acheive. I can work this one for you...</EM></P><P></P><P><EM>Cheers - DV</EM></P></BODY></HTML> Fri, 16 Sep 2011 22:03:35 GMT https://community.qlik.com/t5/QlikView/How-would-I-write-Set-expression-for-different-criterias/m-p/268878#M1187401 IAMDV 2011-09-16T22:03:35Z