topic Re: grouping in QlikView

grouping

Tue, 27 Oct 2015 09:45:46 GMT

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?

Re: grouping

pokassov — Tue, 27 Oct 2015 09:49:40 GMT

Hi!

You can change drill down group on cyclic group.

Re: grouping

morganaaron — Tue, 27 Oct 2015 09:54:34 GMT

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.

Re: grouping

Anonymous — Tue, 27 Oct 2015 10:03:51 GMT

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

Re: grouping

sujeetsingh — Tue, 27 Oct 2015 10:07:40 GMT

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

Re: grouping

santhosh_k_n — Tue, 27 Oct 2015 10:07:47 GMT

Hi,

add following expresion in the drill down group,

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

BR,

Re: grouping

jagan — Tue, 27 Oct 2015 10:16:47 GMT

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.