Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

rathnam_qv
Contributor

Calendar Drill Down issue

Hi All,

I have created a drill-down group like Quarter-->Month-->Date.(Have data only for Current year).


But Quarter is not coming in the drill only Month-->Date is working fine.

What will be the reason for this.

Any help is appreciate.

Thanks,

Muni.

9 Replies
niclaz79
Contributor III

Re: Calendar Drill Down issue

Hi, this would happen if the quarter is not properly defined in your model or if it's not available based on your other selections. Could you provide more info on your model itself?

rathnam_qv
Contributor

Re: Calendar Drill Down issue

Hi Niclas,

I am using single table not joining any other table to it and i am using a DATE filed and calculatin Quarter,Month from it.

Thanks,

Muni.

niclaz79
Contributor III

Re: Calendar Drill Down issue

Is there a chance you can provide the script for calculating the quarter, or even the application itself? It's much easier to click in an actual application to find out where it goes wrong.

rathnam_qv
Contributor

Re: Calendar Drill Down issue

Sorry Niclas...i can't share either query or app.

niclaz79
Contributor III

Re: Calendar Drill Down issue

Ok, then without any screenshots, code or other information it's where hard to figure out what has gone wrong.

rathnam_qv
Contributor

Re: Calendar Drill Down issue

Hi Niclas,

PFB logic which i am using to extract Year,Quarter and Month.

Year(Date_Field) as Year,

'Q' & ceil(month(Date_Field)/3) as Quarter,

Month(Date_Field) as Month,

Thanks,

Muni.

Digvijay_Singh
Honored Contributor III

Re: Calendar Drill Down issue

Do you have a single quarter in your data? Currently there is a bug in drill down design, it skips the dimension and goes to the next one automatically if there is only one value selected or available for that dimension.

Digvijay_Singh
Honored Contributor III

Re: Calendar Drill Down issue

rathnam_qv
Contributor

Re: Calendar Drill Down issue

Yes, Digvijay...i have only single quarter (for 2018).

Is that an issue?

Community Browser