topic Re: Expression Not working in QlikView

Expression Not working

soniasweety — Wed, 25 Nov 2020 16:16:04 GMT

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)

Re: Expression Not working

sunny_talwar — Thu, 07 Sep 2017 12:01:08 GMT

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

Re: Expression Not working

Anil_Babu_Samineni — Thu, 07 Sep 2017 12:04:11 GMT

What does the Flag indicates over here?

Re: Expression Not working

soniasweety — Thu, 07 Sep 2017 12:04:57 GMT

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

sunny_talwar — Thu, 07 Sep 2017 12:06:22 GMT

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

Anil_Babu_Samineni — Thu, 07 Sep 2017 12:07:04 GMT

Does this same - As per calender week

Re: Expression Not working

soniasweety — Thu, 07 Sep 2017 12:07:27 GMT

nothing showing in text object , its kpi object in qliksense

Re: Expression Not working

soniasweety — Thu, 07 Sep 2017 12:08:26 GMT

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

sunny_talwar — Thu, 07 Sep 2017 12:10:22 GMT

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

Anil_Babu_Samineni — Thu, 07 Sep 2017 12:10:46 GMT

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

Re: Expression Not working

soniasweety — Thu, 07 Sep 2017 12:13:57 GMT

Re: Expression Not working

sunny_talwar — Thu, 07 Sep 2017 12:22:17 GMT

Don't know...

Re: Expression Not working

soniasweety — Thu, 07 Sep 2017 12:24:59 GMT

is exp wrong? if I try flag separate selection and variable all working

any other way to show variable with in set analysis?

Re: Expression Not working

sam_grounds — Thu, 07 Sep 2017 12:33:17 GMT

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)

Re: Expression Not working

soniasweety — Thu, 07 Sep 2017 12:49:47 GMT

thanks I will try and let you know

Re: Expression Not working

soniasweety — Fri, 08 Sep 2017 05:37:12 GMT

yes, its working fine thanks

Re: Expression Not working

sam_grounds — Fri, 08 Sep 2017 08:34:32 GMT

No problem, glad it helped!