topic Re: Values showing double after using IntervalMatch table in QlikView

Values showing double after using IntervalMatch table

Rajesh — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am trying to implenting the calendar view and Gantt chart using Pivot table.

To display the data in Gantt chart i have created IntervalMatch table that is displaying data in it as expected, but when i trying to display

in Straight table or Pivot table values showing very high Count.

i couldn't rectify it.

Can any one suggest the solution.

Please find attached QVW.

Thanks

Rajesh

Re: Values showing double after using IntervalMatch table

sunny_talwar — Mon, 06 Aug 2018 12:42:01 GMT

Which tab are we looking at? 'Sheet 1'? And also, which numbers are high? What do you expect them to be (can you share some example based on certain selections)?

Re: Values showing double after using IntervalMatch table

BalaBhaskar_Qlik — Mon, 06 Aug 2018 12:49:40 GMT

It looks like that value occurs at all those levels. Its going to be tricky to handle this entirely in the front end. I expect you will need to change the script to handle this case better.

Share the screen shot of pivot table.

Re: Values showing double after using IntervalMatch table

Rajesh — Mon, 06 Aug 2018 13:01:41 GMT

Hi Sunny thanks for your are responds

In the sheet 1 let say u have selected year 2018 , Month -June, day - 8 the Count should be 21 but it is showing

237 numbers which is wrong.

In sheet2 created Gantt Chart showing perfect Bars as startDate and EndDate data.

Thanks

Rajes

Re: Values showing double after using IntervalMatch table

Rajesh — Mon, 06 Aug 2018 13:07:41 GMT

Re: Values showing double after using IntervalMatch table

sunny_talwar — Mon, 06 Aug 2018 13:10:25 GMT

I might be missing something, but when I select June 8th 2018... I am seeing 237 different Numbers on Sheet2... how are you getting 21? Attaching Excel with all the Numbers I get

Re: Values showing double after using IntervalMatch table

sunny_talwar — Mon, 06 Aug 2018 13:11:45 GMT

Are you looking for a particular Status or something which only results to 21?

Re: Values showing double after using IntervalMatch table

Rajesh — Mon, 06 Aug 2018 13:23:05 GMT

intially i have created pivot table with out using Interval Match table.

Only Used Data, Master Calendar and DateBridge ( In script ) u can check , after that i got a new requirement from my Client that he wants to view in Gantt chart then i found and followed this thred (https://community.qlik.com/docs/DOC-6943#comment-68645) to accomplish this. but in Pivot chart the values are showing wrong.

i hope you got the issue now.

Re: Values showing double after using IntervalMatch table

sunny_talwar — Mon, 06 Aug 2018 13:24:45 GMT

Can you share a sample where you have not used interval match and you are getting 21?

Re: Values showing double after using IntervalMatch table

Rajesh — Mon, 06 Aug 2018 13:25:28 GMT

Not particular one total values showing in pivot chart are wrong

Re: Values showing double after using IntervalMatch table

Rajesh — Mon, 06 Aug 2018 13:44:56 GMT

i have commented IntervalMatch table and 1st DateBridge table , Uncommented the DateBridge1 tab in Script

Please find attached qvw

Re: Values showing double after using IntervalMatch table

sunny_talwar — Mon, 06 Aug 2018 13:55:45 GMT

I might not have understood the use case for implementing interval match if this is not what you wanted (look below)... Let's look a number 'CHG0053904' which has a start date of 09/02/2018 and end date of 28/06/2018.. if you look by the start and end date... this should come up on June 8th 2016... but the solution without interval match doesn't include it on June 8th... On the other hand the solution with interval match does include it on June 8th because June 8th fall between the start and end date. This is true for many other numbers... now if you don't want this to be included on June 8th... why did you implement interval match here?

Re: Values showing double after using IntervalMatch table

Rajesh — Mon, 06 Aug 2018 14:11:22 GMT

As my Client wants to view in Both Pivot table and Gantt chart,

i have implemented IntervalMatch table because to achive Gantt chart in the Sheet2 (1st attched Application v1.2)

Please u can see n check.

in my case not working Both requirements only 1 requirement working by modification of the model.

if u want to reload the application with QVDs i can share.

Re: Values showing double after using IntervalMatch table

sunny_talwar — Mon, 06 Aug 2018 14:16:25 GMT

I don't think I need the qvd... all I need to understand is why do you think it is working on Sheet2, but not on Sheet1? To me, I am getting 237 numbers for June 8th 2018 on Sheet2... just like Sheet1....

Look at this screenshots... is this not what you see?

Re: Values showing double after using IntervalMatch table

Rajesh — Mon, 06 Aug 2018 14:21:16 GMT

This is not i want to show the count in Pivot table.

Re: Values showing double after using IntervalMatch table

sunny_talwar — Mon, 06 Aug 2018 14:28:03 GMT

Then what do you want? Can you elaborate?

Re: Values showing double after using IntervalMatch table

sunny_talwar — Mon, 06 Aug 2018 14:29:14 GMT

May be try this

=If(aggr(count(DISTINCT If(Date = start_date, number)), Week, WeekDay)>2,

Aggr(count(DISTINCT If(Date = start_date, number)), Week, WeekDay) & If(GetFieldSelections(Source)='Change',' Change(s)', If(GetFieldSelections(Source)='Release',' Release(s)', ' Record(s)')),

'')

Re: Values showing double after using IntervalMatch table

Rajesh — Mon, 06 Aug 2018 15:22:13 GMT

can u suggest that how can i achieve two requirements (Pivot chart and Gantt chart )

should i change the model.

Re: Values showing double after using IntervalMatch table

sunny_talwar — Mon, 06 Aug 2018 15:26:03 GMT

Did you get a chance to look at my response below

Re: Values showing double after using IntervalMatch table

Rajesh — Mon, 06 Aug 2018 16:46:05 GMT

Thank you very much Sunny, it solved the issue.