Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
soniasweety
Valued Contributor III

Expression Not working

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)

Tags (5)
1 Solution

Accepted Solutions
sam_grounds
New Contributor III

Re: Expression Not working

Is this not to do with having two sets of '=' symbols? One in your expression and one in the variable.

Try setting This week to

     week(today())

and LastWeek to

     (Week(today())-1)

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

=Count(DISTINCT {$<Week={$(LastWeek)}>} Number)

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

View solution in original post

16 Replies

Re: Expression Not working

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

Re: Expression Not working

What does the Flag indicates over here?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
soniasweety
Valued Contributor III

Re: Expression Not working

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.

Re: Expression Not working

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

Re: Expression Not working

Does this same - As per calender week

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
soniasweety
Valued Contributor III

Re: Expression Not working

nothing showing in text object ,  its kpi object in qliksense

soniasweety
Valued Contributor III

Re: Expression Not working

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

Re: Expression Not working

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

Re: Expression Not working

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)