Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Table with all lines to sum up

Good Morning,

I hope someone of you can help me.

I have a table where I Show all entries of an asset during a year.

But the Problem is that I only see the month "happened" (Screenshot 1).

In my example I wanted to Show as of June 2015.

Screenshot 1

But I Need to see all month (1-12) of 2015. The Table Needs to have the same structure and size, no matter what month we show.

It should always have the actual year (AnBu Jahr) and all periods (AnBu Periode).

From January to June the table Shows happened values and from July to December it should freeze the June-Values (red marked).

Have somebody of you an idea of realising this?

Very much thanks in advance.

Chris

12 Replies

Re: Table with all lines to sum up

Do you have a sample you can share?

Not applicable

Re: Table with all lines to sum up

Hi Sunny,

please find attached my qvw-file.

The can use the green fields to select year and period.

Chris

Re: Table with all lines to sum up

Is this what you want?

Capture.PNG

Not applicable

Re: Table with all lines to sum up

Hi Sunny,

it Looks like it. 2015 is perfect, I think. But could you do me a favor?

Can you try to produce the same for year ='2016'?

The end-of-January 2016 Looks like this.

Thank you.

Chris

Re: Table with all lines to sum up

You don't even have any month after January, what are you expecting to see? If you want to create the complete 2016 you need to create a master calendar with all possible year and months in your application and then you can see them on your chart.

Capture.PNG

Not applicable

Re: Table with all lines to sum up

Hi Sunny,

exactly. I want to see the movements of complete 2016 grouped to periods 1-12.

Even if we are in period 1 of 2016 I Need to see the whole year . From period 2 to 12 the values are frozen.

(like in the pic from above, I copied with example of 2015/4)

Capture.PNG

Would you please help me with this master calendar.

In only have two fields that Need to build the base (rtransyr and rtransper).

Thanks in advance.

Chris

Re: Table with all lines to sum up

I will have to work on the script for this, would you be able to share the source data files so that I can play around and refresh the data?

Not applicable

Re: Table with all lines to sum up

Good Morning Sunny,

please find attached the qvw-file.

you will find the fields rtransyr and rtransper in efa_assettrans

Thank you very much for your help.

Chris

Re: Table with all lines to sum up

All I see in the attached qvw is this:

Capture.PNG

Community Browser