Detached not working

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

Hello Qlik Developers

I am facing an issue with detached option . I have straight table i applied detached option when ever i saved the app close and reopen it the detach option is not working. I have the below expression.

=(sum(UnitActuals.ReceivedCasesFromProc)+

If(IsNull((if(MonthName(max(UnitActuals.ReportedDate))>=MonthName(now()) and UnitActuals.ReportedYear >= Year(now()),

if(BillingRegionType = 'Direct',sum(UnitActuals.ReceivedCasesFromProc)+ sum(UnitActuals.ReceivedTrend)+(DirectUplift*vDirectTerritorycnt)*(((UnitActuals.ReportedYear*12)+UnitActuals.ReportedMonth) - ((year(today())*12)+month(today()))),

if(BillingRegionType = 'INTL',sum(UnitActuals.ReceivedCasesFromProc)+ sum(UnitActuals.ReceivedTrend)+(IntlUplift*vINTLTerritorycnt)*(((UnitActuals.ReportedYear*12)+UnitActuals.ReportedMonth) - ((year(today())*12)+month(today()))),

if(BillingRegionType = 'US Channel',sum(UnitActuals.ReceivedCasesFromProc)+ sum(UnitActuals.ReceivedTrend)+(USChnlUplift*vUSChannelTerritorycnt)*(((UnitActuals.ReportedYear*12)+UnitActuals.ReportedMonth) - ((year(today())*12)+month(today()))),

if(BillingRegionType = 'IVF',sum(UnitActuals.ReceivedCasesFromProc)+ sum(UnitActuals.ReceivedTrend)+(IVFUplift*vIVFTerritorycnt)*(((UnitActuals.ReportedYear*12)+UnitActuals.ReportedMonth) - ((year(today())*12)+month(today()))),

if(MonthName(max(UnitActuals.ReportedDate))>=MonthName(now()),sum(UnitActuals.ReceivedCasesFromProc)+ sum(UnitActuals.ReceivedTrend)+

(If(SubStringCount(Concat(DISTINCT BillingRegionType,','),'Direct')>0,(DirectUplift*vDirectTerritorycnt),0)+

If(SubStringCount(Concat(DISTINCT BillingRegionType,','),'INTL')>0,(IntlUplift*vINTLTerritorycnt),0)+

If(SubStringCount(Concat(DISTINCT BillingRegionType,','),'IVF')>0,(IVFUplift*vIVFTerritorycnt),0)+

If(SubStringCount(Concat(DISTINCT BillingRegionType,','),'US Channel')>0,(USChnlUplift*vUSChannelTerritorycnt),0))*(((UnitActuals.ReportedYear*12)+UnitActuals.ReportedMonth) - ((year(today())*12)+month(today()))),

))))))-sum(UnitActuals.ReceivedCasesFromProc))),0,

((if(MonthName(max(UnitActuals.ReportedDate))>=MonthName(now()) and UnitActuals.ReportedYear >= Year(now()),

if(MonthName(max(UnitActuals.ReportedDate))>=MonthName(now()),sum(UnitActuals.ReceivedCasesFromProc)+ sum(UnitActuals.ReceivedTrend)+

(If(SubStringCount(Concat(DISTINCT BillingRegionType,','),'Direct')>0,(DirectUplift*vDirectTerritorycnt),0)+

If(SubStringCount(Concat(DISTINCT BillingRegionType,','),'INTL')>0,(IntlUplift*vINTLTerritorycnt),0)+

If(SubStringCount(Concat(DISTINCT BillingRegionType,','),'IVF')>0,(IVFUplift*vIVFTerritorycnt),0)+

))))))-sum(UnitActuals.ReceivedCasesFromProc)))))

Sum (UnitActuals.BudgetedCases)

Is there any bug in qlikview? I am using 11.20 SR15 version. Can someone help me please.

Thanks

Anil

Re: Detached not working

vinieme12 — Wed, 14 Dec 2016 21:00:09 GMT

What Exactly with Detached is not working? are you making selections in that Straight table and expecting it to filter?

Selections made in a Detached table applies to other objects except itself and Selection made in other objects doesn't apply to detached objects

Re: Detached not working

dandaanilreddy — Wed, 14 Dec 2016 21:05:14 GMT

Hi Vineeth

In my application i have a list box called toggle which contains 1,3,6,9 and linear growth data. I created a straight table with dimension as toggle and expression is the above what i wrote. Now i want to display total data for toggle in the straight table. If i make any selection the straight table should not effect by default it should display all months. I used detach option for the straight table. when i save and close and again open the app the detach option is not working.

Thanks

Anil

Re: Detached not working

vishsaggi — Wed, 14 Dec 2016 21:11:30 GMT

Detach will not hold when you save and open the document. May be below links might give more info on this:

Detached object does not remain detached; have to re-attach after reload and upon opening document

Re: Detached not working

vinieme12 — Wed, 14 Dec 2016 21:13:10 GMT

If you have made selections and then Selected Detached then that table will be in the same filtered state ,

Clear all Selections and then Detach the table >> Save .

Re: Detached not working

dandaanilreddy — Wed, 14 Dec 2016 21:16:20 GMT

i tried its not working.

Re: Detached not working

vinieme12 — Wed, 14 Dec 2016 21:17:46 GMT

Save AS ! have you tried

Never faced an issue like that

Re: Detached not working

dandaanilreddy — Wed, 14 Dec 2016 21:29:07 GMT

Nope

Its not working.

Re: Detached not working

Wed, 14 Dec 2016 23:59:38 GMT

sometimes objects gets crashed. Try recreating the object without copying the existing one.

-Ashok

topic Re: Detached not working in QlikView

Detached not working

Re: Detached not working

Re: Detached not working

Re: Detached not working

Re: Detached not working

Re: Detached not working

Re: Detached not working

Re: Detached not working

Re: Detached not working