Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

satyapaleti
Contributor II

Total Issue in Qliksene.

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

Count Issue.PNG

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

6 Replies

Re: Total Issue in Qliksene.

Use below

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

ogster1974
Honored Contributor II

Re: Total Issue in Qliksene.

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
Contributor II

Re: Total Issue in Qliksene.

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

Re: Total Issue in Qliksene.

satyapaleti
Contributor II

Re: Total Issue in Qliksene.

Thanq Andy

ogster1974
Honored Contributor II

Re: Total Issue in Qliksene.

no problem

Community Browser