topic Re: How to show the intervals without value? in QlikView

How to show the intervals without value?

katetsan — Wed, 25 Nov 2020 16:16:04 GMT

Hi Communities,

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

Thanks in advanced.

Re: How to show the intervals without value?

avinashelite — Tue, 02 Jan 2018 06:39:37 GMT

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

Re: How to show the intervals without value?

Anil_Babu_Samineni — Tue, 02 Jan 2018 06:39:38 GMT

What is the dimension you used?

Re: How to show the intervals without value?

katetsan — Tue, 02 Jan 2018 06:46:14 GMT

Hi Anil,

Just add two more files. Pls kindly refer it.

Re: How to show the intervals without value?

Anil_Babu_Samineni — Tue, 02 Jan 2018 06:51:07 GMT

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

Re: How to show the intervals without value?

avinashelite — Tue, 02 Jan 2018 07:03:30 GMT

Please the attachment for the solution

Re: How to show the intervals without value?

sasikanth — Tue, 02 Jan 2018 08:03:22 GMT

HI Kate,

Please refer the below link ,

Displaying empty buckets in class function

Thanks,

Sasi

Re: How to show the intervals without value?

qliksus — Thu, 04 Jan 2018 06:13:19 GMT

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;