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: 
katetsan
Creator
Creator

How to show the intervals without value?

Hi Communities,

Is there anyone can tell me how to show the missing interval with class()?

Thanks in advanced.

7 Replies
avinashelite

I feel you don't have data for that interval so it not showing up ..if you need that interval to be created then add a inline table with all the interval and concatenate to the column built out of class function ...then un-check suppress zero from presentation layer

Anil_Babu_Samineni

What is the dimension you used?

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
katetsan
Creator
Creator
Author

Hi Anil,

Just add two more files. Pls kindly refer it.

Anil_Babu_Samineni

I'm sorry i can not open your files currently. Will look for sure if i got chance to open..

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
avinashelite

Please the attachment for the solution


sasikanth
Master
Master

HI Kate,

Please refer the below link ,

Displaying empty buckets in class function

Thanks,

Sasi

qliksus
Specialist II
Specialist II

One solution on the backend would be

ClassFunction:
LOAD   if(IterNo()=2,Ceil(Number+10),Number) as Number , if(IterNo()=2,null(),Name) as Name INLINE [    
    Name, Number
    Alex, 83
    Bob, 10
    Cart, 75
    David, 39
    Eileen, 43
    Frances, 18
    Gary, 82
]

While IterNo()<=2;