Qlik Community

Qlik Sense App Development

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

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

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

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

Community Browser