topic Re: Show last year labels in QlikView

Show last year labels

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

Hello,

I have a Bar Chart with two expressions, the first one is showing the bars and the second one only values on data (The labels).

My second expression is:

Alt(

Num(

(Sum({<Year={'$(=Max(Year))'}>} PNC_S) - above(Aggr(Sum({<Year={'$(=Max(Year)-1)'}>} PNC_S), Month, Year)))

above(Aggr(Sum({<Year={'$(=Max(Year)-1)'}>} PNC_S), Month, Year))

,'#,%')

,' ')

This is showing the change of PNC between the last two years.

The problem is that it is not showing data from the months where 2017 doesnt exist.

I think a solution would be to evaluate for every month if there is any 2017 data.

Re: Show last year labels

MK_QSL — Mon, 23 Jan 2017 15:46:40 GMT

Generating Missing Data In QlikView

Re: Show last year labels

sdaniels0606 — Mon, 23 Jan 2017 15:51:16 GMT

I dont need to generate new data, I just want to avoid the month/year without data.

Re: Show last year labels

MK_QSL — Mon, 23 Jan 2017 15:52:56 GMT

What are the dimensions you have used?

Re: Show last year labels

sdaniels0606 — Mon, 23 Jan 2017 15:54:59 GMT

Month and Year

Re: Show last year labels

Anil_Babu_Samineni — Mon, 23 Jan 2017 15:55:57 GMT

May be remove Aggregation with the Month & Year on expression or else you may sure to provide the sample data which demonstrates the output

Re: Show last year labels

MK_QSL — Mon, 23 Jan 2017 15:58:49 GMT

So you don't want to show Month where data is not present?

If yes, you can select Month in dimension tab and tick Suppress When Value is null.

If this is not what you are looking for.. Kindly explain briefly.

Re: Show last year labels

sdaniels0606 — Mon, 23 Jan 2017 16:00:27 GMT

I cant remove Aggregation because I have a wider datebase, so It helps me to compare data from same months and different years.

Re: Show last year labels

Anil_Babu_Samineni — Mon, 23 Jan 2017 16:02:52 GMT

So, then try Manish latest way or can you describe more for your intend to do with Highlighted one in yellow for your Original post

Re: Show last year labels

sdaniels0606 — Mon, 23 Jan 2017 16:05:22 GMT

Maybe I did not express myself too clear.

I need to show one label for every month. The label has to be the difference between the last 2 years. Like the one highlighted. But, Its only showing the label highlighted. I think its because Its the only month that have 2017 data.

Re: Show last year labels

sdaniels0606 — Mon, 23 Jan 2017 16:07:41 GMT

Re: Show last year labels

Anil_Babu_Samineni — Mon, 23 Jan 2017 16:10:52 GMT

Make sense, Now Turns to questions

1) Do you have Forecast data for 2017?

2) If so, It should show labels for each month

3) If not, You will get only for January because data set may have only for January. Would it be cause it is not showing for another months.

If possible, Can you post the application to work on it the same

Re: Show last year labels

sdaniels0606 — Mon, 23 Jan 2017 16:15:56 GMT

I dont have any forecast for 2017 and I cant post the application due to company rules.

I think a way to solve this would be to evaluate the month. If that month does not have any data becouse of the year, just subtract 1.

But I do not know how to evaluate that.

Re: Show last year labels

Tue, 24 Jan 2017 05:08:59 GMT

can you please post with a dummy data want all the company needs there data o be secured but we can prepare a dummy data and post it in community for the solution