Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
mr_novice
Creator II
Creator II

Drilldown in a histogram

Hi All,

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?

1 Solution

Accepted Solutions
hector_munoz
Specialist
Specialist

Hi Cristian,

Take a look at GetCurrentField() function.

Regards,
H

View solution in original post

3 Replies
hector_munoz
Specialist
Specialist

Hi Cristian,

Take a look at GetCurrentField() function.

Regards,
H

View solution in original post

mr_novice
Creator II
Creator II
Author

Gracias/Thanks Hector!

Didnt think about the GetCurrentField()-function. I did this "if (getcurrentfield(DrillDownDim) = "YearMonth", 'This is Monthly', 'This is daily').

Works perfect!

hector_munoz
Specialist
Specialist

Fantastic!