topic Re: AGGR HELP in QlikView https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858673#M990430 <HTML><HEAD></HEAD><BODY><P>hi tresesco thanks for the spontaneous reply but in my real data model the days filed is from another table and i cant merge it in a single table can pls suggest how to derive the same using fronted expression </P><P></P><P>Thanking you</P><P>Vinayagam</P></BODY></HTML> Mon, 13 Jul 2015 06:40:30 GMT Anonymous 2015-07-13T06:40:30Z AGGR HELP https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858671#M990426 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P>Need help to derive aggr expression by dropping one values of the filed attached herewith the data </P><P></P><P>Thanking You</P><P>Vinayagam</P></BODY></HTML> Mon, 13 Jul 2015 06:15:02 GMT https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858671#M990426 Anonymous 2015-07-13T06:15:02Z Re: AGGR HELP https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858672#M990428 <HTML><HEAD></HEAD><BODY><P>Like this?</P><P></P><P>If(CATEGORY='DS', FieldValue('DAYS',1), DAYS) as NewDAYS</P></BODY></HTML> Mon, 13 Jul 2015 06:33:28 GMT https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858672#M990428 tresB 2015-07-13T06:33:28Z Re: AGGR HELP https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858673#M990430 <HTML><HEAD></HEAD><BODY><P>hi tresesco thanks for the spontaneous reply but in my real data model the days filed is from another table and i cant merge it in a single table can pls suggest how to derive the same using fronted expression </P><P></P><P>Thanking you</P><P>Vinayagam</P></BODY></HTML> Mon, 13 Jul 2015 06:40:30 GMT https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858673#M990430 Anonymous 2015-07-13T06:40:30Z Re: AGGR HELP https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858674#M990431 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Mon, 13 Jul 2015 06:49:18 GMT https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858674#M990431 tresB 2015-07-13T06:49:18Z Re: AGGR HELP https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858675#M990434 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>If you attach some sample with both the tables then it would be easier to solve this.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 13 Jul 2015 06:50:22 GMT https://community.qlik.com/t5/QlikView/AGGR-HELP/m-p/858675#M990434 jagan 2015-07-13T06:50:22Z