Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

why i can't classifie dates in my chart ?

hello,

I want to represent the evolution of tickets in a combo chart but when i put a drill or a dimension of months or week they represented in an alea way ?? not ascending or descending ??

5 Replies
ahaahaaha
Honored Contributor

Re: why i can't classifie dates in my chart ?

Hi,

To help, it would be good to see a fragment of the original data and the result that you want to get.

Not applicable

Re: why i can't classifie dates in my chart ?

the think is it's working when i put months alone or weeks alone they are escending but when i do a drill the months and the weeks are disorganised

Employee
Employee

Re: why i can't classifie dates in my chart ?

You can check "Override Group Sort Order" and choose any order you need/want

Not applicable

Re: why i can't classifie dates in my chart ?

yes it works sometimes but other times no  i don't really what is the problem im gonna chek the data again thanks

Not applicable

Re: why i can't classifie dates in my chart ?

Just for information i have a db of ticketing systeme i can only count the open and close tickets with their dates i tried this expression for the evolution over time sum ( count(closedate)-count(opendates)) but the value is always zero ??