Filter Selection in Bar chart

[yoganantha321]

Hi all,

I have a bar chart listing all the dates in the year 2019 and City on that date as shown in image 1.

Expression used: 1

Image 1:

example scenario 1:

If i filter month as February and the city as Colonge  the bar the chart displaying all the dates for the Colonge city very next to each other.  In image 2, 

Say : it is showing 17/2/2019 very next it is showing 22/2/2019. (17th in pink color and 22nd in brown color in image 2)

Image 2:

My Requirement:

But my expected output is the dates in between also need to be shown as blank(may be color as white). Say dates between 18/2/2019 to 21/2/2019 should be shown. as highlighted in the listbox in the image 3

Image 3:

Example scenario 2:

If i filter multi select of month as Feb, Jun, Aug. Same as above said Displaying Jun very Next to Feb and so on. 

As shown in image 4

Image 4:

I have tried expression with expression  =sum({1}1) But i didn't achieved it. 

I thing I am very clear now in giving my requirements.

Attached my file for reference!!!!!!

Regards,

Yoganantha Prakash G P

[sunny_talwar]

I think you might need to generate the missing data in the script... is that something you are okay to do?

[yoganantha321]

Hi Sunny,

But is it Possible!!!!!

Because the dates changes based on the filter selection.

Whether we can achieve through it?

[sunny_talwar]

---

@yoganantha321 wrote:

Hi Sunny,

But is it Possible!!!!!

Because the dates changes based on the filter selection.

Whether we can achieve through it?

---

Sorry, I didn't understand? Are you asking me that if it is possible to get this fixed after making script changes? Then the answer is Yes AFAIK.

[yoganantha321]

Can you help in this regard of preparing the script

[sunny_talwar]

You can look here on how to generate missing data

Generating Missing Data In QlikView

[yoganantha321]

Hi Sunny,

I have seen and tried with the below script

Date:
LOAD Name,
Date,
Month(Date) as MonthValue
FROM
Learnings\Qlikview\Community\Sampledata1303.xlsx
(ooxml, embedded labels, table is Document_TB01);

Intervals:
LOAD
Name as N_Name,
[Start Date],
[End Date],
City
FROM
Learnings\Qlikview\Community\Sampledata1303.xlsx
(ooxml, embedded labels, table is Document_TB01);;

IntervalMatchBridge:
IntervalMatch (Date) Load distinct [Start Date], [End Date] Resident Intervals;

But it is also displaying my previous output

[yoganantha321]

Actually Sunny!!!!!!

 the dates are not missing. Feb 18 to Feb 21 are not related to the city colonge they are related to the city Valencia. that why it is not showing in the bar.

But i need to show the in between dates as Blank.

[sunny_talwar]

That is exactly the problem... since the combination of Colonge and Feb18 to Feb 21 doesn't exists you will need to create that in the script with may be 0 value... does that make sense?