Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

Re: How to show the intervals without value?

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

Highlighted

Re: How to show the intervals without value?

What is the dimension you used?

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)
Highlighted
Creator
Creator

Re: How to show the intervals without value?

Hi Anil,

Just add two more files. Pls kindly refer it.

Highlighted

Re: How to show the intervals without value?

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

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)
Highlighted

Re: How to show the intervals without value?

Please the attachment for the solution


Highlighted
Specialist III
Specialist III

Re: How to show the intervals without value?

HI Kate,

Please refer the below link ,

Displaying empty buckets in class function

Thanks,

Sasi

Highlighted
Specialist II
Specialist II

Re: How to show the intervals without value?

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;