topic Re: How to achieve the below requirement ? in QlikView

How to achieve the below requirement ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Is there any way to achieve the below chart .

I have the chart below . The requirement is to add the field Flag.

The Flag condition should be .

For eg ,

The UK value - 43101_328 didnt appear in the table more than once thus Flag a 1

Thus ,

same as 43101_1653 ,43101_3373 .

Please take consideration of the whole table such a deal1, dealnm1 . The Flag should be at last.

The red highlighted row are two records . if the number 43101_828 is occuring twice the flag as 0 .

Please kindly assist .

sample model attached..

Re: How to achieve the below requirement ?

qlik4asif — Thu, 08 Mar 2018 10:50:27 GMT

What is the condition for flag?

Re: How to achieve the below requirement ?

chinnuchinni — Thu, 08 Mar 2018 10:52:08 GMT

can you please explore your requirement more ?

Re: How to achieve the below requirement ?

shiveshsingh — Thu, 08 Mar 2018 10:56:06 GMT

Add one more expression

if(column(Put dealnm1 column number) = '-',0,1)

Re: How to achieve the below requirement ?

suvechha_b — Thu, 08 Mar 2018 10:58:34 GMT

The Flag condition should be .

For eg ,

The UK value - 43101_328 didnt appear in the table more than once thus Flag a 1

Thus ,

same as 43101_1653 ,43101_3373 .

Please take consideration of the whole table such a deal1, dealnm1 . The Flag should be at last.

Re: How to achieve the below requirement ?

qlik4asif — Thu, 08 Mar 2018 11:05:26 GMT

Add new expresssion as

If(Count(Disntict UK)=1,1,0)

Re: How to achieve the below requirement ?

suvechha_b — Thu, 08 Mar 2018 11:14:53 GMT

The model is treating the two row as two different rows thus count as 1 thus flag as 1.

I have tried the below query in the script .

"OpenUser_final4":

NoConcatenate

LOAD

UK,

DateJoinKeyPL,

deal1,

dealnm1,

previousdealid,

If(Count(Distinct UK)=1,1,0) as FlagLateststate

Resident "OpenUser_final3"

GROUP BY UK,

DateJoinKeyPL,

deal1,

dealnm1,

previousdealid;

Thus getting the result as

Re: How to achieve the below requirement ?

imrasyed — Thu, 08 Mar 2018 11:26:01 GMT

try to add expression in front end table not at script level

Re: How to achieve the below requirement ?

suvechha_b — Thu, 08 Mar 2018 11:35:31 GMT

The output is same.

Re: How to achieve the below requirement ?

qlik4asif — Thu, 08 Mar 2018 13:48:19 GMT

I don't have qlikview installed in my system .

Try this

If(Count(Total <UK> UK)=1,1,0)

If(Count(<UK> UK)=1,1,0)