Expression Not working

[soniasweety]

Hi all,

I created the variables

LastWeek =Week(today())-1     result:35

his week=week(today())     result:36

but when I use the below expression sometime its working some time its not working?    what is the issue?

below separate expresions tried  both giving some time correct sometime wrong.

=Count({<Flag={'1'},WeekNumber={'=$(ThisWeek)'}>}distinct Id)

=count({$<Week={$(=LastWeek)}>}distinct Number)

=Count({$<Flag={'0'},WeekNumber={$(=LastWeek)}>}distinct No)

[sunny_talwar]

Can you explain when it does give correct result and when it doesn't?

[Anil_Babu_Samineni]

What does the Flag indicates over here?

[soniasweety]

expected output is

actually,  I don't have the data for 36 and 35th week  it should show zero  but it is not displaying anything if I put in text object

and the variables are working fine.  if I try in text objects.

[sunny_talwar]

Text box is not even showing 0? or is this in straight table or pivot table? If it is in a straight or pivot table, you might have to uncheck 'Suppress Zero Values' on the presentation tab of chart properties

[Anil_Babu_Samineni]

Does this same - As per calender week

[soniasweety]

nothing showing in text object ,  its kpi object in qliksense

[soniasweety]

yes anil,

flag is  I have two diff tables so I want to show the count of one table   I created flag for it because two tables concatenated

[sunny_talwar]

Can you show an image of what you see when the value for current week is 36 and value for previous week is 35?

[Anil_Babu_Samineni]

I agree, Then we might need more information related data and expect result set