topic Re: Missing Dates over Bar Chart,Scatter Chart object and start Date and end date for Alternate States in QlikView

Missing Dates over Bar Chart,Scatter Chart object and start Date and end date for Alternate States

Thu, 22 Oct 2015 13:37:38 GMT

Hello Everyone,

Can someone help me with below three Issues.

1)I have dataset with missing dates..in below chart we can observe 2012-Q1,2012-Q2,2014-Q4,2013-Q1...User want see missing dates with Data not available Bar...

How can i get them?????

2)In scatter plot we have bubble size according to Count(value). But user is looking for Color gradient should be according to Count..and bubble should be replaced with Squares...below picture for reference.

3)Other requirement is, I need Start date and end date(range of data) for alternate states.

Thanks in advance,

venkat

hari1352‌ bangardeepak‌ qlikviewwizard‌ jgd‌ engishfaque‌

Re: Missing Dates over Bar Chart,Scatter Chart object and start Date and end date for Alternate States

qlikviewwizard — Thu, 22 Oct 2015 14:11:29 GMT

Hi,

Create a separate master calender to get the missing dates and link with your script.

Master Calendar Data

Hope this will help you.

Re: Missing Dates over Bar Chart,Scatter Chart object and start Date and end date for Alternate States

Thu, 22 Oct 2015 14:41:36 GMT

Thanks for response bro.

When i work on this code....I can see all Months...but values on bar are constant

It should be as

Thanks

venkat

Re: Missing Dates over Bar Chart,Scatter Chart object and start Date and end date for Alternate States

qlikviewwizard — Thu, 22 Oct 2015 15:57:44 GMT

Hi Venkat,

I did not understand your issue. Please attach the sample data.

Re: Missing Dates over Bar Chart,Scatter Chart object and start Date and end date for Alternate States

Thu, 22 Oct 2015 17:35:35 GMT

I need Bar chart with

Expression: Count(Distinct Parent Record Id )

Dimensions: 1) Year, MonthName, QuaterName (Cyclic Group)

2) Interaction Type, Interaction Subtype(Drilldown)