topic Re: dimenssion in QlikView https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290366#M403570 <HTML><HEAD></HEAD><BODY><P>wat abt c?&nbsp; </P></BODY></HTML> Tue, 22 Nov 2016 09:41:38 GMT Chanty4u 2016-11-22T09:41:38Z dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290365#M403569 <HTML><HEAD></HEAD><BODY><P>i want to use sth like this in my dimenssion:</P><P>max(date)</P><P>how can i do it?</P><P></P><P></P><P>i have some table like below:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>company</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>sales</STRONG></TH></TR><TR><TD style="padding: 2px;">a</TD><TD style="padding: 2px;">1</TD></TR><TR><TD style="padding: 2px;">a</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">b</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">c</TD><TD style="padding: 2px;">4</TD></TR><TR><TD style="padding: 2px;">d</TD><TD style="padding: 2px;">5</TD></TR></TBODY></TABLE><P>i want pevot like below:</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>company</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Header 2</STRONG></TH></TR><TR><TD style="padding: 2px;">a</TD><TD style="padding: 2px;">2</TD></TR><TR><TD style="padding: 2px;">b</TD><TD style="padding: 2px;">3</TD></TR><TR><TD style="padding: 2px;">d</TD><TD style="padding: 2px;">5</TD></TR><TR><TD style="padding: 2px;">c</TD><TD style="padding: 2px;">4</TD></TR></TBODY></TABLE><P>i should use sale field in dimenssion</P></BODY></HTML> Tue, 22 Nov 2016 09:37:39 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290365#M403569 omid5ive 2016-11-22T09:37:39Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290366#M403570 <HTML><HEAD></HEAD><BODY><P>wat abt c?&nbsp; </P></BODY></HTML> Tue, 22 Nov 2016 09:41:38 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290366#M403570 Chanty4u 2016-11-22T09:41:38Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290367#M403571 <HTML><HEAD></HEAD><BODY><P>not clear what you want to achieve</P><P>why is a 2 and not 3 (the sum)?</P><P>why is c missing?</P><P>Please elaborate</P></BODY></HTML> Tue, 22 Nov 2016 09:42:12 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290367#M403571 giakoum 2016-11-22T09:42:12Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290368#M403572 <HTML><HEAD></HEAD><BODY><P>Can you provide a sample that replicates your scenario, you've said you want to have "Sale" in dimension but your output table doesn't show how?</P><P></P><P>Can you create a sample in Excel with data and desired output</P></BODY></HTML> Tue, 22 Nov 2016 09:42:32 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290368#M403572 vinieme12 2016-11-22T09:42:32Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290369#M403573 <HTML><HEAD></HEAD><BODY><P>may b&nbsp; this?<IMG alt="fsv.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144448_fsv.PNG" style="height: 147px; width: 620px;" /></P></BODY></HTML> Tue, 22 Nov 2016 09:42:34 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290369#M403573 Chanty4u 2016-11-22T09:42:34Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290370#M403574 <HTML><HEAD></HEAD><BODY><P>because the maximum number af a is 2 and want to show the maximum number of each company in my pivot</P></BODY></HTML> Tue, 22 Nov 2016 09:43:58 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290370#M403574 omid5ive 2016-11-22T09:43:58Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290371#M403575 <HTML><HEAD></HEAD><BODY><P>i have to use it in dimensio i cant use this in dim</P></BODY></HTML> Tue, 22 Nov 2016 09:45:31 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290371#M403575 omid5ive 2016-11-22T09:45:31Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290372#M403576 <HTML><HEAD></HEAD><BODY><P>sorry i edited it</P></BODY></HTML> Tue, 22 Nov 2016 09:45:42 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290372#M403576 omid5ive 2016-11-22T09:45:42Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290373#M403577 <HTML><HEAD></HEAD><BODY><P>Max(sales) then as expression in the pivot table?</P></BODY></HTML> Tue, 22 Nov 2016 09:45:48 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290373#M403577 giakoum 2016-11-22T09:45:48Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290374#M403578 <HTML><HEAD></HEAD><BODY><P>i need to use it in dimensio not in expression</P></BODY></HTML> Tue, 22 Nov 2016 09:47:01 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290374#M403578 omid5ive 2016-11-22T09:47:01Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290375#M403579 <HTML><HEAD></HEAD><BODY><P>aggr(Max(sales), company) as calculated dimension</P></BODY></HTML> Tue, 22 Nov 2016 09:48:23 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290375#M403579 giakoum 2016-11-22T09:48:23Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290376#M403580 <HTML><HEAD></HEAD><BODY><P>Hi Omid,</P><P></P><P>select dimension as company</P><P>in expression write as max(sales)</P><P></P><P>u may get ur requirement</P><P></P><P>for reference pls have a look in to my attachment</P><P></P><P></P><P></P><P>Regards</P><P>Hemanth</P></BODY></HTML> Tue, 22 Nov 2016 09:49:23 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290376#M403580 hemanthaanichet 2016-11-22T09:49:23Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290377#M403581 <HTML><HEAD></HEAD><BODY><P>try below then</P><P></P><P>add in caluclated dimension tab<IMG alt="ca.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/144476_ca.PNG" style="height: 152px; width: 620px;" /></P><P>=Aggr(Max(sales), company)</P></BODY></HTML> Tue, 22 Nov 2016 09:51:10 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290377#M403581 Chanty4u 2016-11-22T09:51:10Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290378#M403582 <HTML><HEAD></HEAD><BODY><P>becasue of i need chenge the location of this field i should use it in dim</P></BODY></HTML> Tue, 22 Nov 2016 09:51:26 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290378#M403582 omid5ive 2016-11-22T09:51:26Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290379#M403583 <HTML><HEAD></HEAD><BODY><P>In the dimension try exp like:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =<SPAN style="font-size: 10pt;">Aggr(max(sales), company)</SPAN></P></BODY></HTML> Tue, 22 Nov 2016 09:53:39 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290379#M403583 tresB 2016-11-22T09:53:39Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290380#M403584 <HTML><HEAD></HEAD><BODY><P>thanks a lot</P></BODY></HTML> Tue, 22 Nov 2016 09:54:07 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290380#M403584 omid5ive 2016-11-22T09:54:07Z Re: dimenssion https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290381#M403585 <HTML><HEAD></HEAD><BODY><P>welcome:)</P></BODY></HTML> Tue, 22 Nov 2016 10:00:30 GMT https://community.qlik.com/t5/QlikView/dimenssion/m-p/1290381#M403585 Chanty4u 2016-11-22T10:00:30Z