Total Issue in Qliksene.

[SatyaPaleti]

Hi Friends,

Can any one of you guys please help in resolving this issue. Total is applying to whole expression what i have written

Expression :-

count(Total <Week> Distinct(if(([Status Flag] = 'Fully Paid') and ([Code] <> 'CREDIT'),[Id])))

Here is the Image How I am Getting Result

Same Expression I am using in Qlikview it's working fine but It's not working in Qliksense.

Please find attached document for Sample Data & Sample Qvf

Thank you,

Satya paleti

[MK_QSL]

Use below

COUNT({<[Status Flag] = {'Fully Paid'}, Code -= {'CREDIT'} >}DISTINCT Id)

[ogster1974]

If you just have week the number as your dimension you get values.  Its when you add 'WW' to week you lose the context.

[SatyaPaleti]

Hi Manish,

Thank you for Quick Reply. Your Expression is working fine. Could you please forward your email Id. So That I can send what the exact requirement is

[MK_QSL]

mrkachhiaimp@gmail.com

[SatyaPaleti]

Thanq Andy

[ogster1974]

no problem