Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
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.
Do you have a sample you can share?
please find attached my qvw-file.
The can use the green fields to select year and period.
Is this what you want?
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.
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.
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)
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.
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?
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.
All I see in the attached qvw is this: