Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
axel_bgd
Contributor II

if match : Confirm function :

Hi,

Can someone please tell me if it's possible to use Match function in my request?

In my application I've two differents date: entry and exit

I created a special calendar in order to know the numbers of présents, I find the solution by intervalmatch..

Now, I would like to calculate the numbers of peole entry and exit :

I've no idea to translate this condition in my table...

I tried the condition but is not working.

Maybe I need to use the if match but any one can help me.

if(Entry_date = Present_date,1,0) as Flag_Enty

Thanks!

A.

Tags (1)
1 Solution

Accepted Solutions

Re: if match : Confirm function :

Maybe :

if ( Match ( Entry_date , concat ( Present_date , ',' ) ,1,0) as Flag_Enty

Have not tested it so may have a typo and may need a dollar expansion around the concat like this :

if ( Match ( Entry_date , $(concat ( Present_date , ',' ))  ,1,0) as Flag_Enty

View solution in original post

6 Replies
YoussefBelloum
Esteemed Contributor

Re: if match : Confirm function :

Hi,

if(Entry_date = Present_date,1,0) as Flag_Enty


the syntax looks good

can you take a screen shot from your script (where you have this Flag field) and another one from your table sctructure ?

gerry_hdm
Contributor II

Re: if match : Confirm function :

benutz du eine chartbox zum anzeigen ?

Re: if match : Confirm function :

Maybe :

if ( Match ( Entry_date , concat ( Present_date , ',' ) ,1,0) as Flag_Enty

Have not tested it so may have a typo and may need a dollar expansion around the concat like this :

if ( Match ( Entry_date , $(concat ( Present_date , ',' ))  ,1,0) as Flag_Enty

View solution in original post

axel_bgd
Contributor II

Re: if match : Confirm function :

Sorry but I don't speak German ...

gerry_hdm
Contributor II

Re: if match : Confirm function :

Apology for the German answer
I wasn't paying attention.

greeting Gerold

axel_bgd
Contributor II

Re: if match : Confirm function :

No problem

Best,

A