<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Expression update for every week in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Expression-update-for-every-week/m-p/445031#M567764</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Hello everyone ,&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;In my chart ı have two expressions one of them&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;count(IF(ISTEK_DURUM='Açık',ISTEK_DURUM))&amp;nbsp; (requests' statu : Open)&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;second expression&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;=Count({&amp;lt;ISTEK_ACISTARIHI2 = {"&amp;lt;=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açık'}&amp;gt;} ISTEK_ACISTARIHI2)&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;requests' statu open over 30 days&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;As you see below for each bagining of week , I want to display updated data but my second expression updates based on today not for every beginning of week&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;&lt;A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-282502-25279/istek.png" style="color: #007fc0;"&gt;&lt;IMG __jive_id="25281" class="jive-image-thumbnail jive-image jiveImage" height="179" alt="istek.png" src="https://community.qlik.com/legacyfs/online/25281_istek.png" style="border-color: transparent;" width="450" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;my date dimension is :&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Mon, 19 Nov 2012 10:43:31 GMT</pubDate>
    <dc:creator>QSense</dc:creator>
    <dc:date>2012-11-19T10:43:31Z</dc:date>
    <item>
      <title>Expression update for every week</title>
      <link>https://community.qlik.com/t5/QlikView/Expression-update-for-every-week/m-p/445031#M567764</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Hello everyone ,&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;In my chart ı have two expressions one of them&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;count(IF(ISTEK_DURUM='Açık',ISTEK_DURUM))&amp;nbsp; (requests' statu : Open)&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;second expression&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;=Count({&amp;lt;ISTEK_ACISTARIHI2 = {"&amp;lt;=$(=Timestamp(Today() - 30, 'DD.MM.YYYY hh:mm:ss'))"},ISTEK_DURUM={'Açık'}&amp;gt;} ISTEK_ACISTARIHI2)&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;requests' statu open over 30 days&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;As you see below for each bagining of week , I want to display updated data but my second expression updates based on today not for every beginning of week&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;&lt;A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-282502-25279/istek.png" style="color: #007fc0;"&gt;&lt;IMG __jive_id="25281" class="jive-image-thumbnail jive-image jiveImage" height="179" alt="istek.png" src="https://community.qlik.com/legacyfs/online/25281_istek.png" style="border-color: transparent;" width="450" /&gt;&lt;/A&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;my date dimension is :&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;date(WeekStart(ISTEK_ACISTARIHI2),'DD.MM.YYYY')&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 19 Nov 2012 10:43:31 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Expression-update-for-every-week/m-p/445031#M567764</guid>
      <dc:creator>QSense</dc:creator>
      <dc:date>2012-11-19T10:43:31Z</dc:date>
    </item>
  </channel>
</rss>

