Zero values missing on X axis despite using Master Calendar

[Anonymous]

I have used a master calendar to generate missing calendar months..

Missing months are appearing on the X axis as along as I uncheck 'Show All values' from the Dimensions tab

As a result even if I select specific few months to see the trend it shows all the months instead of the required months.

When i uncheck the 'Show all values' box the graph responds to the selection but the missing months dont appear.

Attached is my file.

[Anonymous]

Thanks for the suggestion..Let me try it ..I am keeping this thread open and if I get a solution will close this thread.

[sunny_talwar]

Sounds good....

[Anonymous]

Hi Sunny

I made some headway based on what you said in terms of generating missing data for the missing calendar months.

I used the script from the blog of 'How to populate a sparsely populated field' by Henric Cronstrom

I am attaching the application.  If you select the new application 'CONNECt' i get the missing months and the selection is as per the months selected and zero values appear for the missing months. But this works fine only for one application as in the script i have written

f(IsNull([Ticket Number]),'CONNECT',Application) as New_Application

Would you be able to suggest from your experience how do i link this to all the application i..e. i need to populate Application value for all the tickets wherever the ticket nuumber is blank. so effectively it should repeat with 0 zero value for all the applications.

any ideas on this are appreciated

[sunny_talwar]

Would you be able to share this file?

Impact Trend.xlsx

[Anonymous]

Attaching the sheet.. I did a workaround for this.

I created multiple rows with ticket number = 0 and attached application value to it by using

if(IsNull([Ticket Number]),'0',[Ticket Number]) as [Ticket Number],
if(IsNull([Ticket Number]),'CONNECT,HSBCNET,Clientsphere,Core Trade,CoreDocs,CRS,CWT,OKYC,RF,RM Portal,RRT,SCS AI',Application) as New_Application1,

Then in the expression i had to subtract the count of tickets iwht zero value.

fabs(count(distinct [Ticket Number])-count(distinct {<[Ticket Number]={'0'}>}[Ticket Number]))

[Anil_Babu_Samineni]

Then in the expression i had to subtract the count of tickets iwht zero value.

fabs(count(distinct [Ticket Number])-count(distinct {<[Ticket Number]={'0'}>}[Ticket Number]))

May be this?

count({< [Ticket Number] = {'*'}-{'0'}>}[Ticket Number])

Or

count({< [Ticket Number] -= {'0'}>}[Ticket Number])

[sunny_talwar]

Is it working now?

[sunny_talwar · Accepted solution]

Check the attached now and see if this is the move towards the right direction

[Anonymous]

Thanks Sunny...it works fine ..got the solution finally

[sunny_talwar]

Nice, please close the thread by marking the correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny