Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how do on a graph that has a dimension cyclic group containing year and two months to make different calculations.

Good Afternoon,

as I do on a graph that has a dimension cyclic group containing year and two months to make different calculations.

example:

How could I do to select year when he makes a speech and when selected another month's calculation.

Att,

JH

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use the getcurrentfield function to retrieve the currently active field in the cyclic group. Something like this:

if(getcurrentfield(MyGroupNameHere)='Year', ...year_expression..., ...month_expression...)

See attached example.


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

You can use the getcurrentfield function to retrieve the currently active field in the cyclic group. Something like this:

if(getcurrentfield(MyGroupNameHere)='Year', ...year_expression..., ...month_expression...)

See attached example.


talk is cheap, supply exceeds demand
Not applicable
Author

Thank you,
JH