<?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 Help me to write the following expression in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Help-me-to-write-the-following-expression/m-p/659667#M1078696</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;How to write in expression :&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;if([Fiscal Year] is not selected and [Fiscal Month] is not selected)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;[Fiscal Year], [Fiscal Month] are filters.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;eg,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;=if ([Fiscal Year]=' ' and [Fiscal Month] =' ',&lt;/P&gt;&lt;P&gt;Sum({&amp;lt;[period_key]={$(vMaxPeriod)},[Fiscal Year],[Fiscal Month]=&amp;gt;}inventory_on_hand-qa_blocked_stock),&lt;/P&gt;&lt;P&gt;Sum({&amp;lt;[period_key]={$(vMon)}inventory_on_hand-qa_blocked_stock))&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 11 Jul 2014 11:05:59 GMT</pubDate>
    <dc:creator>suvechha_b</dc:creator>
    <dc:date>2014-07-11T11:05:59Z</dc:date>
    <item>
      <title>Help me to write the following expression</title>
      <link>https://community.qlik.com/t5/QlikView/Help-me-to-write-the-following-expression/m-p/659667#M1078696</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;How to write in expression :&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;if([Fiscal Year] is not selected and [Fiscal Month] is not selected)&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;[Fiscal Year], [Fiscal Month] are filters.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;eg,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;=if ([Fiscal Year]=' ' and [Fiscal Month] =' ',&lt;/P&gt;&lt;P&gt;Sum({&amp;lt;[period_key]={$(vMaxPeriod)},[Fiscal Year],[Fiscal Month]=&amp;gt;}inventory_on_hand-qa_blocked_stock),&lt;/P&gt;&lt;P&gt;Sum({&amp;lt;[period_key]={$(vMon)}inventory_on_hand-qa_blocked_stock))&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 11 Jul 2014 11:05:59 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Help-me-to-write-the-following-expression/m-p/659667#M1078696</guid>
      <dc:creator>suvechha_b</dc:creator>
      <dc:date>2014-07-11T11:05:59Z</dc:date>
    </item>
    <item>
      <title>Re: Help me to write the following expression</title>
      <link>https://community.qlik.com/t5/QlikView/Help-me-to-write-the-following-expression/m-p/659668#M1078697</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;to know if a field has selections or not use GetSelectedCount(Field)&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 11 Jul 2014 11:09:41 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Help-me-to-write-the-following-expression/m-p/659668#M1078697</guid>
      <dc:creator>ali_hijazi</dc:creator>
      <dc:date>2014-07-11T11:09:41Z</dc:date>
    </item>
    <item>
      <title>Re: Help me to write the following expression</title>
      <link>https://community.qlik.com/t5/QlikView/Help-me-to-write-the-following-expression/m-p/659669#M1078698</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;if(not getselectedcount([Fiscal Year]) and not getselectedcount([Fiscal Month]), &lt;EM&gt;...true..., ...false...&lt;/EM&gt; )&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 11 Jul 2014 11:11:11 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Help-me-to-write-the-following-expression/m-p/659669#M1078698</guid>
      <dc:creator>Gysbert_Wassenaar</dc:creator>
      <dc:date>2014-07-11T11:11:11Z</dc:date>
    </item>
  </channel>
</rss>

