topic Re: How to restrict only one value from dimension in a chart in QlikView https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426330#M158836 <HTML><HEAD></HEAD><BODY><P>=count({1&lt;Customer_ID={'YOURSPECIFICID'}&gt;} customers)</P></BODY></HTML> Sun, 05 May 2013 09:29:02 GMT 2013-05-05T09:29:02Z How to restrict only one value from dimension in a chart https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426329#M158835 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>i have a Bar chart and in want to do this :</P><P></P><P>Count distinct on (type custome) , and i want to do it only on a specific cuatomer_id .</P><P></P><P>How do i restrict specific&nbsp; value from Customer dimension in a chart ?</P><P></P><P>Thank you </P></BODY></HTML> Sun, 05 May 2013 09:22:21 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426329#M158835 2013-05-05T09:22:21Z Re: How to restrict only one value from dimension in a chart https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426330#M158836 <HTML><HEAD></HEAD><BODY><P>=count({1&lt;Customer_ID={'YOURSPECIFICID'}&gt;} customers)</P></BODY></HTML> Sun, 05 May 2013 09:29:02 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426330#M158836 2013-05-05T09:29:02Z Re: How to restrict only one value from dimension in a chart https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426331#M158837 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>first thank you it works </P><P>but i don't understand how ? <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>what "1" stand for ?</P><P>where we did count distinct .</P></BODY></HTML> Sun, 05 May 2013 09:37:20 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426331#M158837 2013-05-05T09:37:20Z Re: How to restrict only one value from dimension in a chart https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426332#M158838 <HTML><HEAD></HEAD><BODY><P>sorry i forgot distinct</P><P></P><P>=count({1&lt;Customer_ID={'YOURSPECIFICID'}&gt;} distinct customers)</P><P></P><P>1 stands for that it is not affected by any selection.</P><P></P><P>I think you also could use $ cause your are specifiying what value it should be, so i does not matter. </P></BODY></HTML> Sun, 05 May 2013 09:53:51 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426332#M158838 2013-05-05T09:53:51Z Re: How to restrict only one value from dimension in a chart https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426333#M158839 <HTML><HEAD></HEAD><BODY><P>thank you </P><P>it been very helpful</P></BODY></HTML> Sun, 05 May 2013 09:55:55 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426333#M158839 2013-05-05T09:55:55Z Re: How to restrict only one value from dimension in a chart https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426334#M158840 <HTML><HEAD></HEAD><BODY><P>i found strange thing&nbsp; !</P><P></P><P>when i use the this syntax in the graf&nbsp; i get what i want.</P><P> but when i change the filter ( for example month) </P><P>the garf doesnt change ,why ? </P></BODY></HTML> Sun, 05 May 2013 13:02:03 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426334#M158840 2013-05-05T13:02:03Z Re: How to restrict only one value from dimension in a chart https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426335#M158841 <HTML><HEAD></HEAD><BODY><P>because you have set 1 infront. Try with $</P><P></P><P>one disregards the dimensions but not the selection..</P><P></P><P>and if that does not work</P><P></P><P>then try</P><P></P><P><SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">=count({$&lt;Customer_ID={'YOURSPECIFICID'}, MONTHCOLUMN=&gt;} distinct customers)</SPAN></P></BODY></HTML> Sun, 05 May 2013 13:08:06 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426335#M158841 2013-05-05T13:08:06Z Re: How to restrict only one value from dimension in a chart https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426336#M158842 <HTML><HEAD></HEAD><BODY><P>thank you again</P></BODY></HTML> Sun, 05 May 2013 13:11:34 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426336#M158842 2013-05-05T13:11:34Z Re: How to restrict only one value from dimension in a chart https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426337#M158843 <HTML><HEAD></HEAD><BODY><P>did it work?</P></BODY></HTML> Sun, 05 May 2013 13:21:50 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-only-one-value-from-dimension-in-a-chart/m-p/426337#M158843 2013-05-05T13:21:50Z