<?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 Re: set analysis with function in modifier in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/set-analysis-with-function-in-modifier/m-p/1803206#M1211882</link>
    <description>&lt;P&gt;HI&amp;nbsp;&lt;/P&gt;&lt;P&gt;Try like below&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;count({$&amp;lt;&lt;/SPAN&gt;&lt;STRONG&gt;B&lt;/STRONG&gt;&lt;SPAN&gt;={'*2021*'}&amp;gt;}[&lt;/SPAN&gt;&lt;STRONG&gt;A&lt;/STRONG&gt;&lt;SPAN&gt;])&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;or being Year field and use like below&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;count({&amp;lt;YearField={2021}&amp;gt;}A)&lt;/SPAN&gt;&lt;/P&gt;</description>
    <pubDate>Tue, 27 Apr 2021 15:37:32 GMT</pubDate>
    <dc:creator>MayilVahanan</dc:creator>
    <dc:date>2021-04-27T15:37:32Z</dc:date>
    <item>
      <title>set analysis with function in modifier</title>
      <link>https://community.qlik.com/t5/QlikView/set-analysis-with-function-in-modifier/m-p/1803153#M1211876</link>
      <description>&lt;P&gt;Hello&lt;/P&gt;&lt;P&gt;I would like to have a graph which have as expression the count of the field [&lt;STRONG&gt;&lt;FONT face="andale mono,times"&gt;A]&lt;/FONT&gt;&lt;/STRONG&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="andale mono,times"&gt;but it should count the line only if the date field [&lt;STRONG&gt;B] &lt;/STRONG&gt;is a date in 2021&lt;BR /&gt;&lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;&lt;FONT face="andale mono,times"&gt;So i wanted to have a set analysis like &lt;/FONT&gt;&lt;/P&gt;&lt;P&gt;count({$&amp;lt;year([&lt;STRONG&gt;B&lt;/STRONG&gt;)={'2021'}&amp;gt;}[&lt;STRONG&gt;A&lt;/STRONG&gt;])&lt;/P&gt;&lt;P&gt;It appears it doesn't work when there is a function in the modifier, is it true ? what i don't understand, thanks !&lt;/P&gt;</description>
      <pubDate>Tue, 27 Apr 2021 13:37:40 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/set-analysis-with-function-in-modifier/m-p/1803153#M1211876</guid>
      <dc:creator>hillrunner</dc:creator>
      <dc:date>2021-04-27T13:37:40Z</dc:date>
    </item>
    <item>
      <title>Re: set analysis with function in modifier</title>
      <link>https://community.qlik.com/t5/QlikView/set-analysis-with-function-in-modifier/m-p/1803206#M1211882</link>
      <description>&lt;P&gt;HI&amp;nbsp;&lt;/P&gt;&lt;P&gt;Try like below&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;count({$&amp;lt;&lt;/SPAN&gt;&lt;STRONG&gt;B&lt;/STRONG&gt;&lt;SPAN&gt;={'*2021*'}&amp;gt;}[&lt;/SPAN&gt;&lt;STRONG&gt;A&lt;/STRONG&gt;&lt;SPAN&gt;])&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;or being Year field and use like below&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;count({&amp;lt;YearField={2021}&amp;gt;}A)&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 27 Apr 2021 15:37:32 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/set-analysis-with-function-in-modifier/m-p/1803206#M1211882</guid>
      <dc:creator>MayilVahanan</dc:creator>
      <dc:date>2021-04-27T15:37:32Z</dc:date>
    </item>
  </channel>
</rss>

