topic Re: If match statment? in QlikView

If match statment?

Thu, 12 Nov 2015 10:57:32 GMT

Hi guys,

I need to solve this problem and cant get my head around it,

I have a statight table that looks like this. I need a calculation that shows the value 1 if a single SSN has the value smoke and snuff on a matching date. Ive tryed a if match statment like this but cant get i right

if(Match(Signed,SSN, Rökare and Snusare='1', 1)

SSN	Signed	Smoke	Snuff
565656	2015-07-01 10:38	1	-
565656	2015-07-01 10:38	-	1

Any ideas?

Re: If match statment?

Anonymous — Thu, 12 Nov 2015 11:07:08 GMT

can we try like:

if(Signed='1' or SSN='1' or Rökare='1' or Snusare='1', 1)

or depend on what you need

if(Signed='1' and SSN='1' and Rökare='1' and Snusare='1', 1)

Re: If match statment?

buzzy996 — Thu, 12 Nov 2015 11:18:30 GMT

are u looking for this?

Re: If match statment?

sunny_talwar — Thu, 12 Nov 2015 11:25:55 GMT

Not really sure how you data is structured, would you be able to prepare a small sample?

Re: If match statment?

Mark_Little — Thu, 12 Nov 2015 14:39:40 GMT

Hi,

Shiva's proposed solution seems to show the correct answer, but as Sunny has suggested a small data set or QVW would help, as I would suggest looking at the data model, I would normally expect the to see you example as one line.

SSN	Signed	Smoke	Snuff
565656	2015-07-01 10:38	1	1

Then the set analysis would be easy, or even script a flag.

Mark