topic need help in query in QlikView https://community.qlik.com/t5/QlikView/need-help-in-query/m-p/543507#M1145978 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>I have a requirement to create qvw file.</P><P>I have two a column which contains columns one is <STRONG>Dept</STRONG> and other is <STRONG>Region</STRONG> values as 'hr','manager','ceo','sales','accounts','crest','audit','payments','insurance','finance' and some blank values in my access table. I need to create a report by considering this column so I need to see the report like below by taking the FILTER by <STRONG>Region </STRONG>as I have 9 Regions</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="275" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 402px; HEIGHT: 227px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 4</STRONG></SPAN></TH></TR><TR><TD><STRONG>Dept</STRONG></TD><TD><STRONG>In</STRONG></TD><TD><STRONG>Out</STRONG></TD><TD><STRONG>current</STRONG></TD></TR><TR><TD>hr</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>manager</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>ceo</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>sales</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>accounts</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>crest</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>audit</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>payments</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>insurance</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>finance</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>I need to get count of hr,manager,ceo and so on in the fileds In, Out,Current by considering the same <STRONG>Dept </STRONG>column to get In,Out, Current.</P><P>Could anyone help me how to write the script for this.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 31 Jul 2013 09:33:38 GMT 2013-07-31T09:33:38Z need help in query https://community.qlik.com/t5/QlikView/need-help-in-query/m-p/543507#M1145978 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>I have a requirement to create qvw file.</P><P>I have two a column which contains columns one is <STRONG>Dept</STRONG> and other is <STRONG>Region</STRONG> values as 'hr','manager','ceo','sales','accounts','crest','audit','payments','insurance','finance' and some blank values in my access table. I need to create a report by considering this column so I need to see the report like below by taking the FILTER by <STRONG>Region </STRONG>as I have 9 Regions</P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="275" style="BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; WIDTH: 402px; HEIGHT: 227px; BORDER-TOP: #000000 1px solid; BORDER-RIGHT: #000000 1px solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 1</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 2</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 3</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Header 4</STRONG></SPAN></TH></TR><TR><TD><STRONG>Dept</STRONG></TD><TD><STRONG>In</STRONG></TD><TD><STRONG>Out</STRONG></TD><TD><STRONG>current</STRONG></TD></TR><TR><TD>hr</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>manager</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>ceo</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>sales</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>accounts</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>crest</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>audit</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>payments</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>insurance</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>finance</TD><TD></TD><TD></TD><TD></TD></TR></TBODY></TABLE><P></P><P>I need to get count of hr,manager,ceo and so on in the fileds In, Out,Current by considering the same <STRONG>Dept </STRONG>column to get In,Out, Current.</P><P>Could anyone help me how to write the script for this.</P><P></P><P>Thanks.</P></BODY></HTML> Wed, 31 Jul 2013 09:33:38 GMT https://community.qlik.com/t5/QlikView/need-help-in-query/m-p/543507#M1145978 2013-07-31T09:33:38Z