topic Re: RE:Convert to Sql in QlikView

RE:Convert to Sql

Chanty4u — Wed, 06 Apr 2016 05:35:55 GMT

Hi all,

I have small conversion on Qlikview Expression into SQl.

Below is my Qlikview code. I need tis in Sql.

Count({<[USER]=e({<[NEW]={'A','B','C'}>})>}distinct [USER])/count(distinct USER)

Re: RE:Convert to Sql

PrashantSangle — Wed, 06 Apr 2016 05:40:29 GMT

Create flag in script for Column New

and use it in Set analysis.

Load *

If(Wildmatch(New,'A','B','C'),1,0) as flag

from table;

then your expression became

Count({<Flag={'0'}>}Distinct USER)/Count(Distinct USER)

Regards

Re: RE:Convert to Sql

Kushal_Chawda — Wed, 06 Apr 2016 05:47:21 GMT

SELECT (SUM(a.USERCOUNTE)/SUM(a.TOTALUSER)) as USERNEW

FROM (

SELECT COUNT(DISTINCT b.USER) as TOTALUSER,COUNT(SELECT DISTINCT USER FROM TABLE WHERE USER NOT IN ('A','B','C')) as USERCOUNTE

FROM TABLE b ) a

UPDATE

Re: RE:Convert to Sql

Chanty4u — Wed, 06 Apr 2016 05:50:17 GMT

Hi Max,

i need the equivalent sql code for testing in db.

Not in Qlivkiew

Re: RE:Convert to Sql

Wed, 06 Apr 2016 05:50:51 GMT

select COUNT(distinct b.[USER])/count(distinct a.[USER]) from tablename a,tablenamae b

where b.[NEW]='A' or b.[NEW]='B' or b.[NEW]='C'

Re: RE:Convert to Sql

Chanty4u — Wed, 06 Apr 2016 05:53:37 GMT

Thnx Kush. i will try this code and let u know

Re: RE:Convert to Sql

Chanty4u — Wed, 06 Apr 2016 05:53:49 GMT

Thnx Oza. i will try this code and let u know

Re: RE:Convert to Sql

PrashantSangle — Wed, 06 Apr 2016 06:39:01 GMT

Hi,

try below

select

(select

count(t1.USER)

From table t1

where NAME NOT IN ('A','B','C')

)

/ count (t2.USER)

From table t2

Regards