topic Re: Drilldown in a histogram in QlikView https://community.qlik.com/t5/QlikView/Drilldown-in-a-histogram/m-p/1276923#M400920 <HTML><HEAD></HEAD><BODY><P>Gracias/Thanks Hector!</P><P></P><P>Didnt think about the GetCurrentField()-function. I did this <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">"if (getcurrentfield(DrillDownDim) = "YearMonth", 'This is Monthly', 'This is daily').</SPAN></P><P></P><P>Works perfect!</P></BODY></HTML> Wed, 15 Feb 2017 11:15:17 GMT mr_novice 2017-02-15T11:15:17Z Drilldown in a histogram https://community.qlik.com/t5/QlikView/Drilldown-in-a-histogram/m-p/1276921#M400918 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have a very simple histogram with a drill down dimension (or group) consisting of two fields - YearMonth and Date. The group is called "DrillDownDim". My expression is sum(sales)/count(distinct Date). This works fine. What I want to do is change the title in chart depending on the level of DrillDownDim. I would like to do something like this: "if (DrillDownDim = "YearMonth", 'This is Monthly', 'This is daily'). How can accomplish this?</P></BODY></HTML> Wed, 15 Feb 2017 10:12:52 GMT https://community.qlik.com/t5/QlikView/Drilldown-in-a-histogram/m-p/1276921#M400918 mr_novice 2017-02-15T10:12:52Z Re: Drilldown in a histogram https://community.qlik.com/t5/QlikView/Drilldown-in-a-histogram/m-p/1276922#M400919 <HTML><HEAD></HEAD><BODY><P>Hi Cristian,</P><P></P><P>Take a look at GetCurrentField() function.</P><P></P><P>Regards,<BR />H</P></BODY></HTML> Wed, 15 Feb 2017 10:24:01 GMT https://community.qlik.com/t5/QlikView/Drilldown-in-a-histogram/m-p/1276922#M400919 hector_munoz 2017-02-15T10:24:01Z Re: Drilldown in a histogram https://community.qlik.com/t5/QlikView/Drilldown-in-a-histogram/m-p/1276923#M400920 <HTML><HEAD></HEAD><BODY><P>Gracias/Thanks Hector!</P><P></P><P>Didnt think about the GetCurrentField()-function. I did this <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">"if (getcurrentfield(DrillDownDim) = "YearMonth", 'This is Monthly', 'This is daily').</SPAN></P><P></P><P>Works perfect!</P></BODY></HTML> Wed, 15 Feb 2017 11:15:17 GMT https://community.qlik.com/t5/QlikView/Drilldown-in-a-histogram/m-p/1276923#M400920 mr_novice 2017-02-15T11:15:17Z Re: Drilldown in a histogram https://community.qlik.com/t5/QlikView/Drilldown-in-a-histogram/m-p/1276924#M400921 <HTML><HEAD></HEAD><BODY><P>Fantastic!</P></BODY></HTML> Wed, 15 Feb 2017 11:59:46 GMT https://community.qlik.com/t5/QlikView/Drilldown-in-a-histogram/m-p/1276924#M400921 hector_munoz 2017-02-15T11:59:46Z