Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yoganantha321
Creator II
Creator II

Filter Selection in Bar chart

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:

Image1.JPG

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:

Image2.JPG

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:

Image3.JPG

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:

Image4.JPG

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

 

Labels (1)
8 Replies
sunny_talwar

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

yoganantha321
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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?