topic Re: eliminate the duplicate the in stright table in QlikView https://community.qlik.com/t5/QlikView/eliminate-the-duplicate-the-in-stright-table/m-p/447641#M565975 <HTML><HEAD></HEAD><BODY><P>thank for uer&nbsp; reply</P><P> i create the two&nbsp; calender <A></A> starting&nbsp; date and ending&nbsp; date&nbsp;&nbsp;&nbsp; depending on the selection&nbsp;&nbsp; the&nbsp; data&nbsp; should be shown ,</P></BODY></HTML> Tue, 18 Dec 2012 14:36:16 GMT 2012-12-18T14:36:16Z eliminate the duplicate the in stright table https://community.qlik.com/t5/QlikView/eliminate-the-duplicate-the-in-stright-table/m-p/447639#M565973 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>&nbsp; i use&nbsp; two calender&nbsp; b/w&nbsp; the range&nbsp; but&nbsp; expression not&nbsp; working,dupicates coming </P></BODY></HTML> Tue, 18 Dec 2012 13:07:43 GMT https://community.qlik.com/t5/QlikView/eliminate-the-duplicate-the-in-stright-table/m-p/447639#M565973 2012-12-18T13:07:43Z Re: eliminate the duplicate the in stright table https://community.qlik.com/t5/QlikView/eliminate-the-duplicate-the-in-stright-table/m-p/447640#M565974 <HTML><HEAD></HEAD><BODY><P>I don't know what you're trying to do. Your calendar objects are not used to make selections, so all dates are shown in your straight table. Is that what you want to change? See attached qvw for how to make that work (look at the Variable Event Triggers).</P><P></P><P>You mention duplicates. Can you explain what you mean? I don't see any duplicate records in the screenshot of your straight table.</P><P></P><P>The expression </P><P>&nbsp;&nbsp;&nbsp;&nbsp; =Count(DISTINCT if( BUDAT&gt;= $(Vstart Date) AND BUDAT &lt;= $(VEndDate), MANDT))</P><P>can be rewritten as</P><P>&nbsp;&nbsp;&nbsp;&nbsp; =Count({&lt;BUDAT={"&gt;= $(Vstart Date)&lt;= $(VEndDate)"} &gt;} DISTINCT MANDT)</P></BODY></HTML> Tue, 18 Dec 2012 14:20:34 GMT https://community.qlik.com/t5/QlikView/eliminate-the-duplicate-the-in-stright-table/m-p/447640#M565974 Gysbert_Wassenaar 2012-12-18T14:20:34Z Re: eliminate the duplicate the in stright table https://community.qlik.com/t5/QlikView/eliminate-the-duplicate-the-in-stright-table/m-p/447641#M565975 <HTML><HEAD></HEAD><BODY><P>thank for uer&nbsp; reply</P><P> i create the two&nbsp; calender <A></A> starting&nbsp; date and ending&nbsp; date&nbsp;&nbsp;&nbsp; depending on the selection&nbsp;&nbsp; the&nbsp; data&nbsp; should be shown ,</P></BODY></HTML> Tue, 18 Dec 2012 14:36:16 GMT https://community.qlik.com/t5/QlikView/eliminate-the-duplicate-the-in-stright-table/m-p/447641#M565975 2012-12-18T14:36:16Z