topic Re: need help regarding the dimension in QlikView

need help regarding the dimension

agni_gold — Sun, 07 Jun 2015 06:52:52 GMT

I have a situation that , i have created the year_Month field but some of the data is not coming for some month , suppose for Nov-2014 , there is no data in my source , and no month selected when that iD is selected in the listbox ,

Now if i want to show the month in dimension , how can i do it .

Re: need help regarding the dimension

kaushiknsolanki — Sun, 07 Jun 2015 06:54:33 GMT

Hi,

Create a master calendar and link that with your data.

Regards,

Kaushik Solanki

Re: need help regarding the dimension

agni_gold — Sun, 07 Jun 2015 07:38:01 GMT

I have created and linked , but for NOV-2014 there is no source data , therefore NOV-2014 is not showing in dimension . But I just want to show the 0 value for these type of records . Don't want to miss the months in dimension.

Re: need help regarding the dimension

kaushiknsolanki — Sun, 07 Jun 2015 07:42:51 GMT

Dear Kumar,

Do not create master calendar using the same field.

Create a master calendar using the min and max date and then link that to your data.

Sample Master Cal script is:

Let vMin = num(makedate(2015,01,01));

Let vMax = num(today());

Temp:

Load Date($(vMin) + rowno() -1) as Date

Autogenerate 1

While Date($(vMin) + rowno() -1) < Date($(vMax));

MatserCal:

Load Date,

Month(Date) as Month,

Year(Date) as Year

Resident Temp;

Drop table Temp;

Regards,

Kaushik Solanki

Re: need help regarding the dimension

MarcoWedel — Sun, 07 Jun 2015 08:20:04 GMT

Hi,

try to uncheck "suppress zero-values" and/or "suppress missing" on the presentation tab of the chart properties.

hope this helps

regards

Marco

Re: need help regarding the dimension

agni_gold — Sun, 07 Jun 2015 08:27:59 GMT

no it is not working

Re: need help regarding the dimension

MarcoWedel — Sun, 07 Jun 2015 08:35:53 GMT

please post a sample application.

regards

Marco

Re: need help regarding the dimension

MarcoWedel — Sun, 07 Jun 2015 16:04:37 GMT

Hi,

one example:

tabData:
LOAD Date#(year_Month,'MMM-YYYY') as year_Month,
    Value
INLINE [
    year_Month, Value
    Jan-2014, 10
    Feb-2014, 20
    Apr-2014, 30
    Jun-2014, 40
    Jul-2014, 50
    Sep-2014, 60
    Oct-2014, 70
    Dec-2014, 80
];

tabMonthCalendar:
LOAD Date(AddMonths(MakeDate(2014),RecNo()-1),'MMM-YYYY') as year_Month
AutoGenerate 12;

hope this helps

regards

Marco

Re: need help regarding the dimension

agni_gold — Mon, 08 Jun 2015 06:14:48 GMT

i tried that also, but it is also not working for me.