Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

grouping


In my dashboard i have three field in drill down Date, hour, minute,. When i have only one date available,in x axis date level wont display it directly goes to hour level. any solution for this?

6 Replies
pokassov
Specialist
Specialist

Hi!

You can change drill down group on cyclic group.

morganaaron
Specialist
Specialist

That's the default behaviour of a drill down group. Pretty simple solution - don't use a drill down group! You can use a cyclic group if you'd prefer to switch yourself, or you can use a calculated dimension and control when you want the date to switch - this could be done using variables to allow the user to choose or you can code your own logic.

Anonymous
Not applicable
Author

Hi Nilanjan,

Its as per design,default behavior of drill down group.

you can control date field, if only one value is present, by adding value or calculated dimension

as Aaron said.

Regards

Neetha

sujeetsingh
Master III
Master III

Change the group to cyclic one and adjust the field order and sortings.

santhosh_k_n
Creator II
Creator II

Hi,

add following expresion in the drill down group,

if(GetPossibleCount(Date)=1,hours,Date)

BR,

SK

jagan
Luminary Alumni
Luminary Alumni

Hi,

That is the default behaviour of Drilldown groups, in case if you want to override that try like below

Dimensions:

Date  , Enable Conditional : =GetSelectedCount(Hour) = 0  AND GetSelectedCount(Minute) = 0

Hour, Enable Conditional : =GetSelectedCount(Date) > 0  AND GetSelectedCount(Minute) = 0  AND GetSelectedCount(Hour) = 0

Minute, Enable Conditional : =GetSelectedCount(Date) > 0  AND GetSelectedCount(Hour) > 0


Hope this helps you.

Regards,

Jagan.