topic Datenmodell Inventurtabelle und Detailinformationen in App Development https://community.qlik.com/t5/App-Development/Datenmodell-Inventurtabelle-und-Detailinformationen/m-p/1833929#M68851 <P>Hallo Zusammen,</P><P>ich bin Neuling und mache mir Gedanken, wie ich mein Datenmodel sauber und performant aufstellen kann.</P><P>Die <STRONG>erste Tabelle ist eine Inventurtabelle</STRONG> aus dem Quellsystem und nicht änderbar. Die zweite Tabelle enthält Details zur Inventurtabelle. Mir ist nicht ganz klar, wie ich eine <STRONG>"Verbindung"</STRONG> zwischen beiden erstellen kann--ich möchte ungern die Detailinformationen verlieren zu den Out/ Open Flows.</P><P>Tab Inventur:</P><TABLE><TBODY><TR><TD>Datum</TD><TD>Team</TD><TD>Flow</TD><TD>Anzahl</TD><TD>AVG Alter</TD></TR><TR><TD>29.08.2021</TD><TD>abc</TD><TD>Open</TD><TD>10</TD><TD>3,0</TD></TR><TR><TD>29.08.2021</TD><TD>abc</TD><TD>Out</TD><TD>5</TD><TD>&nbsp;</TD></TR><TR><TD>29.08.2021</TD><TD>def</TD><TD>Open</TD><TD>21</TD><TD>7,0</TD></TR><TR><TD>29.08.2021</TD><TD>mno</TD><TD>Open</TD><TD>3</TD><TD>8,0</TD></TR><TR><TD>29.08.2021</TD><TD>pqr</TD><TD>Open</TD><TD>48</TD><TD>33.6</TD></TR><TR><TD><STRONG><FONT color="#000080">30.08.2021</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">abc</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">OUT</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">10</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">8,4</FONT></STRONG></TD></TR><TR><TD><STRONG><FONT color="#000080">30.08.2021</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">abc</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">Open</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">15</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">41,3</FONT></STRONG></TD></TR><TR><TD><STRONG><FONT color="#000080">30.08.2021</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">abc</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">IN</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">1235</FONT></STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>30.08.2021</TD><TD>def</TD><TD>OUT</TD><TD>6</TD><TD>17,0</TD></TR><TR><TD>30.08.2021</TD><TD>def</TD><TD>Open</TD><TD>51</TD><TD>88,0</TD></TR><TR><TD>30.08.2021</TD><TD>def</TD><TD>IN</TD><TD>12</TD><TD>&nbsp;</TD></TR><TR><TD>30.08.2021</TD><TD>mno</TD><TD>OUT</TD><TD>28</TD><TD>11,0</TD></TR><TR><TD>30.08.2021</TD><TD>mno</TD><TD>Open</TD><TD>91</TD><TD>12,0</TD></TR><TR><TD>30.08.2021</TD><TD>pqr</TD><TD>OUT</TD><TD>7</TD><TD><P>56,0</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Tabelle Detail Bsp anhand Team abc</P><TABLE><TBODY><TR><TD>Stichtag</TD><TD>Mailfach</TD><TD>Team</TD><TD>Status</TD><TD>Kanal</TD><TD>Grund</TD><TD>Ursache&nbsp;</TD><TD>Flow</TD><TD>Alter</TD><TD>Anz</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>1</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>Open</TD><TD>46</TD><TD>1</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>1</TD><TD>System</TD><TD>Kundenwunsch</TD><TD>Kunde</TD><TD>Open</TD><TD>10</TD><TD>2</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>2</TD><TD>System</TD><TD>Aktiver Rückruf</TD><TD>Firma</TD><TD>Open</TD><TD>44</TD><TD>1</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>2</TD><TD>Manuell</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>Open</TD><TD>21</TD><TD>3</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>2</TD><TD>Manuell</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>OUT</TD><TD>6</TD><TD>2</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>2</TD><TD>Manuell</TD><TD>Aktiver Rückruf</TD><TD>Kunde</TD><TD>OUT</TD><TD>10</TD><TD>2</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Aktiver Rückruf</TD><TD>Kunde</TD><TD>Offen</TD><TD>5</TD><TD>6</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>Offen</TD><TD>122</TD><TD>2</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>OUT</TD><TD>5</TD><TD>1</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Firma</TD><TD>OUT</TD><TD>13</TD><TD>3</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Berater</TD><TD>OUT</TD><TD>8</TD><TD>2</TD></TR></TBODY></TABLE> Mon, 06 Sep 2021 09:20:11 GMT ChillVibes 2021-09-06T09:20:11Z Datenmodell Inventurtabelle und Detailinformationen https://community.qlik.com/t5/App-Development/Datenmodell-Inventurtabelle-und-Detailinformationen/m-p/1833929#M68851 <P>Hallo Zusammen,</P><P>ich bin Neuling und mache mir Gedanken, wie ich mein Datenmodel sauber und performant aufstellen kann.</P><P>Die <STRONG>erste Tabelle ist eine Inventurtabelle</STRONG> aus dem Quellsystem und nicht änderbar. Die zweite Tabelle enthält Details zur Inventurtabelle. Mir ist nicht ganz klar, wie ich eine <STRONG>"Verbindung"</STRONG> zwischen beiden erstellen kann--ich möchte ungern die Detailinformationen verlieren zu den Out/ Open Flows.</P><P>Tab Inventur:</P><TABLE><TBODY><TR><TD>Datum</TD><TD>Team</TD><TD>Flow</TD><TD>Anzahl</TD><TD>AVG Alter</TD></TR><TR><TD>29.08.2021</TD><TD>abc</TD><TD>Open</TD><TD>10</TD><TD>3,0</TD></TR><TR><TD>29.08.2021</TD><TD>abc</TD><TD>Out</TD><TD>5</TD><TD>&nbsp;</TD></TR><TR><TD>29.08.2021</TD><TD>def</TD><TD>Open</TD><TD>21</TD><TD>7,0</TD></TR><TR><TD>29.08.2021</TD><TD>mno</TD><TD>Open</TD><TD>3</TD><TD>8,0</TD></TR><TR><TD>29.08.2021</TD><TD>pqr</TD><TD>Open</TD><TD>48</TD><TD>33.6</TD></TR><TR><TD><STRONG><FONT color="#000080">30.08.2021</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">abc</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">OUT</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">10</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">8,4</FONT></STRONG></TD></TR><TR><TD><STRONG><FONT color="#000080">30.08.2021</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">abc</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">Open</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">15</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">41,3</FONT></STRONG></TD></TR><TR><TD><STRONG><FONT color="#000080">30.08.2021</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">abc</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">IN</FONT></STRONG></TD><TD><STRONG><FONT color="#000080">1235</FONT></STRONG></TD><TD>&nbsp;</TD></TR><TR><TD>30.08.2021</TD><TD>def</TD><TD>OUT</TD><TD>6</TD><TD>17,0</TD></TR><TR><TD>30.08.2021</TD><TD>def</TD><TD>Open</TD><TD>51</TD><TD>88,0</TD></TR><TR><TD>30.08.2021</TD><TD>def</TD><TD>IN</TD><TD>12</TD><TD>&nbsp;</TD></TR><TR><TD>30.08.2021</TD><TD>mno</TD><TD>OUT</TD><TD>28</TD><TD>11,0</TD></TR><TR><TD>30.08.2021</TD><TD>mno</TD><TD>Open</TD><TD>91</TD><TD>12,0</TD></TR><TR><TD>30.08.2021</TD><TD>pqr</TD><TD>OUT</TD><TD>7</TD><TD><P>56,0</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Tabelle Detail Bsp anhand Team abc</P><TABLE><TBODY><TR><TD>Stichtag</TD><TD>Mailfach</TD><TD>Team</TD><TD>Status</TD><TD>Kanal</TD><TD>Grund</TD><TD>Ursache&nbsp;</TD><TD>Flow</TD><TD>Alter</TD><TD>Anz</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>1</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>Open</TD><TD>46</TD><TD>1</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>1</TD><TD>System</TD><TD>Kundenwunsch</TD><TD>Kunde</TD><TD>Open</TD><TD>10</TD><TD>2</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>2</TD><TD>System</TD><TD>Aktiver Rückruf</TD><TD>Firma</TD><TD>Open</TD><TD>44</TD><TD>1</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>2</TD><TD>Manuell</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>Open</TD><TD>21</TD><TD>3</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>2</TD><TD>Manuell</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>OUT</TD><TD>6</TD><TD>2</TD></TR><TR><TD>30.08.2021</TD><TD>2nd-Level&nbsp;</TD><TD>abc</TD><TD>2</TD><TD>Manuell</TD><TD>Aktiver Rückruf</TD><TD>Kunde</TD><TD>OUT</TD><TD>10</TD><TD>2</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Aktiver Rückruf</TD><TD>Kunde</TD><TD>Offen</TD><TD>5</TD><TD>6</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>Offen</TD><TD>122</TD><TD>2</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Kunde</TD><TD>OUT</TD><TD>5</TD><TD>1</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Firma</TD><TD>OUT</TD><TD>13</TD><TD>3</TD></TR><TR><TD>30.08.2021</TD><TD>3rd-Level&nbsp;</TD><TD>abc</TD><TD>3</TD><TD>System</TD><TD>Falscher Kunden</TD><TD>Berater</TD><TD>OUT</TD><TD>8</TD><TD>2</TD></TR></TBODY></TABLE> Mon, 06 Sep 2021 09:20:11 GMT https://community.qlik.com/t5/App-Development/Datenmodell-Inventurtabelle-und-Detailinformationen/m-p/1833929#M68851 ChillVibes 2021-09-06T09:20:11Z