Solved: Re: TRAMOS DE DÍAS - Qlik Community - 2004754

Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.

Skip to main content

Qlik.com | Qlik Services | Qlik Help

Ask a Question

¿Qué formula tengo que poner para tener tramos de días?

Por ejemplo:

0 a 15

16 a 30

31 a 60

61 a 90

90 a 180

más de 180 días

Gracias

1 Solution

Accepted Solutions

if(fieldname>180,'180 days'

,if(fieldname>90,'91 to 180 Days'

,if(fieldname>60,'61 to 90 Days'

,if(fieldname>30,'31 to 60 Days'

,if(fieldname>15,'15 to 30 Days','0 to 15 days'))))) as DayGrouping

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply

if(fieldname>180,'180 days'

,if(fieldname>90,'91 to 180 Days'

,if(fieldname>60,'61 to 90 Days'

,if(fieldname>30,'31 to 60 Days'

,if(fieldname>15,'15 to 30 Days','0 to 15 days'))))) as DayGrouping

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.