<?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 Use a calculated dimension in a formula in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/Use-a-calculated-dimension-in-a-formula/m-p/1583155#M42623</link>
    <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;In the storyboard, I want to define a calculated dimension called vINSTRUCTION that I will use in many formula.&lt;/P&gt;&lt;P&gt;Here is the calculated dimension :&amp;nbsp;if(IsNull([RATIO.INSTRUCTION]), [ERRORS.INSTRUCTION], [RATIO.INSTRUCTION])&lt;/P&gt;&lt;P&gt;I tried to create a formula like Count(vINSTRUCTION) but vINSTRUCTION does not appear in the dimension pane.&lt;/P&gt;&lt;P&gt;I also tried to do this as a variable but the formula count(vINSTRUCTION) count the dimension as a variable not as dimension (return 1).&lt;/P&gt;&lt;P&gt;Does know a way to keep this calculated dimension in some sort a variable so I can re-use it in many formula.&lt;/P&gt;&lt;P&gt;Best regards.&lt;/P&gt;</description>
    <pubDate>Sat, 16 Nov 2024 05:46:38 GMT</pubDate>
    <dc:creator>ClementByr</dc:creator>
    <dc:date>2024-11-16T05:46:38Z</dc:date>
    <item>
      <title>Use a calculated dimension in a formula</title>
      <link>https://community.qlik.com/t5/App-Development/Use-a-calculated-dimension-in-a-formula/m-p/1583155#M42623</link>
      <description>&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;In the storyboard, I want to define a calculated dimension called vINSTRUCTION that I will use in many formula.&lt;/P&gt;&lt;P&gt;Here is the calculated dimension :&amp;nbsp;if(IsNull([RATIO.INSTRUCTION]), [ERRORS.INSTRUCTION], [RATIO.INSTRUCTION])&lt;/P&gt;&lt;P&gt;I tried to create a formula like Count(vINSTRUCTION) but vINSTRUCTION does not appear in the dimension pane.&lt;/P&gt;&lt;P&gt;I also tried to do this as a variable but the formula count(vINSTRUCTION) count the dimension as a variable not as dimension (return 1).&lt;/P&gt;&lt;P&gt;Does know a way to keep this calculated dimension in some sort a variable so I can re-use it in many formula.&lt;/P&gt;&lt;P&gt;Best regards.&lt;/P&gt;</description>
      <pubDate>Sat, 16 Nov 2024 05:46:38 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Use-a-calculated-dimension-in-a-formula/m-p/1583155#M42623</guid>
      <dc:creator>ClementByr</dc:creator>
      <dc:date>2024-11-16T05:46:38Z</dc:date>
    </item>
  </channel>
</rss>

