Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register 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?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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..

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
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;