topic Re: Logic Help !!! in QlikView

Logic Help !!!

amit_saini — Fri, 12 Jan 2018 11:25:08 GMT

Hi Folks,

I'm calling below dim and exp in a line chart:

Dim :

=if(isnull(GetFieldSelections(Week))=0,

if(Week<=SubField(GetFieldSelections(Week),',',-1),Week),

if(isnull(GetFieldSelections(Month))=0,

Week<=aggr(max(Week),$Field),

if(Week<=53,Week)))

Exp:

rangesum(above((Count(DISTINCT{<Month,Year={'2017'},Week,

Product_Group_N={'CVS'},

Complaint_Classification={'0-km Complaint'},Complaint_Type_Description={'Supplier'}>} NRQNR)),0,RowNo()))

Now when I'm selecting any week lets say in below case 7 , it should show all the prior weeks including 7 , which is working absolutely fine. See below:

The same concept should work for Month also, when I'm selecting Feb , it should show me all weeks data from Jan until selected Feb , but currently it's not working this way.

Any suggestions???

Regards,

Re: Logic Help !!!

Anil_Babu_Samineni — Fri, 12 Jan 2018 11:31:02 GMT

May be share sample to test?

Re: Logic Help !!!

amit_saini — Fri, 12 Jan 2018 11:42:52 GMT

PFA!

Regards,

Re: Logic Help !!!

sunny_talwar — Fri, 12 Jan 2018 11:49:20 GMT

Why don't you try this

Dimension

Week

Expression

RangeSum(Above((Count(DISTINCT{<Year={'2017'},Month, Week = {"$(='<=' & Max(Week))"}>} CVS)),0,RowNo()))

Re: Logic Help !!!

amit_saini — Fri, 12 Jan 2018 11:59:31 GMT

Thank you once again!

Regards,