<?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 Conditional InputSum In PivotTable in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Conditional-InputSum-In-PivotTable/m-p/462411#M560957</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;in this PivotTable the Column "Verkaufte Lizenzen" should be Inputfields.&lt;/P&gt;&lt;P&gt;It works, when I just declare InputSum([Verkaufte Lizenzen]).&lt;/P&gt;&lt;P&gt;The result is:&lt;/P&gt;&lt;P&gt;&lt;IMG alt="CondInputSum0.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/39006_CondInputSum0.JPG" width="450" /&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG class="jiveImage" height="218" src="https://community.qlik.com/message/336334/" style="max-width: 1200px; max-height: 900px;" width="455" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I just want the input field if Dimension Ziel = "Lizenzverkauf"&lt;/P&gt;&lt;P&gt;So I defined a condition:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #3366ff;"&gt;if&lt;/SPAN&gt; (&lt;SPAN style="color: #993366;"&gt;Zie&lt;/SPAN&gt;l='Lizenzverkauf',&lt;SPAN style="color: #3366ff;"&gt;InputSum&lt;/SPAN&gt;(&lt;SPAN style="color: #993366;"&gt;[Verkaufte Lizenzen]&lt;/SPAN&gt;))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;But when conditioning the input by an IF-Condition it won't by an InputField more&lt;/P&gt;&lt;P&gt;and the manual input value is show in the correct row.&lt;/P&gt;&lt;P&gt;&lt;IMG __jive_id="39003" alt="CondInputSum.JPG" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/39003_CondInputSum.JPG" width="450" /&gt;&lt;/P&gt;&lt;P&gt;I want this and an inputfield as well. Is there any chance to manage this?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;THX in andvance and best regards.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Udo&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 17 Apr 2013 10:51:52 GMT</pubDate>
    <dc:creator />
    <dc:date>2013-04-17T10:51:52Z</dc:date>
    <item>
      <title>Conditional InputSum In PivotTable</title>
      <link>https://community.qlik.com/t5/QlikView/Conditional-InputSum-In-PivotTable/m-p/462411#M560957</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;in this PivotTable the Column "Verkaufte Lizenzen" should be Inputfields.&lt;/P&gt;&lt;P&gt;It works, when I just declare InputSum([Verkaufte Lizenzen]).&lt;/P&gt;&lt;P&gt;The result is:&lt;/P&gt;&lt;P&gt;&lt;IMG alt="CondInputSum0.JPG" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/39006_CondInputSum0.JPG" width="450" /&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG class="jiveImage" height="218" src="https://community.qlik.com/message/336334/" style="max-width: 1200px; max-height: 900px;" width="455" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I just want the input field if Dimension Ziel = "Lizenzverkauf"&lt;/P&gt;&lt;P&gt;So I defined a condition:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #3366ff;"&gt;if&lt;/SPAN&gt; (&lt;SPAN style="color: #993366;"&gt;Zie&lt;/SPAN&gt;l='Lizenzverkauf',&lt;SPAN style="color: #3366ff;"&gt;InputSum&lt;/SPAN&gt;(&lt;SPAN style="color: #993366;"&gt;[Verkaufte Lizenzen]&lt;/SPAN&gt;))&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;But when conditioning the input by an IF-Condition it won't by an InputField more&lt;/P&gt;&lt;P&gt;and the manual input value is show in the correct row.&lt;/P&gt;&lt;P&gt;&lt;IMG __jive_id="39003" alt="CondInputSum.JPG" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/39003_CondInputSum.JPG" width="450" /&gt;&lt;/P&gt;&lt;P&gt;I want this and an inputfield as well. Is there any chance to manage this?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;THX in andvance and best regards.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Udo&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 17 Apr 2013 10:51:52 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Conditional-InputSum-In-PivotTable/m-p/462411#M560957</guid>
      <dc:creator />
      <dc:date>2013-04-17T10:51:52Z</dc:date>
    </item>
  </channel>
</rss>

