Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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)

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

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
Highlighted

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

Highlighted

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)
Highlighted
Specialist III
Specialist III

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.

Highlighted

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

Highlighted

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)
Highlighted
Specialist III
Specialist III

nothing showing in text object ,  its kpi object in qliksense

Highlighted
Specialist III
Specialist III

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

Highlighted

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

Highlighted

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)