Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

set analysis doesn't work if i select a month or a week but worked for the whole period

Hi,

this set analysis works well but if i select anything it gives me wrong result.

anyhelp please

sum({<Date={">$(=mindate)<$(=Date(mindate"+365))"}>}
if(IsNum(Right(Badgeages,5))=-1,if([Code d'entreprise]='12',
interval(num(Time#('02:00','hh:mm')),'hh:mm'),
interval(num(Time#('01:00','hh:mm')),'hh:mm'))))

5 Replies
MK_QSL
MVP
MVP

sum({<Month = , Week = , MonthYear =, Quarter= , Date={">$(=mindate)<$(=Date(mindate"+365))"}>}

if(IsNum(Right(Badgeages,5))=-1,if([Code d'entreprise]='12',

interval(num(Time#('02:00','hh:mm')),'hh:mm'),

interval(num(Time#('01:00','hh:mm')),'hh:mm'))))


I have doubt whether this is ok or no

Date={">$(=mindate)<$(=Date(mindate"+365))

Not applicable
Author

the selection doesn't work.

did you have any idera how to write this : Date={">$(=mindate)<$(=Date(mindate"+365))              in another way

lironbaram
Partner - Master III
Partner - Master III

you can go with

Date = {">$(=min(mindate)) <$(=addmonths(min(mindate),12))"}

Not applicable
Author

not working

sasiparupudi1
Master III
Master III

Please post your qvw here