topic Re: Ignoring repeating values in staright table in QlikView

Ignoring repeating values in staright table

montubhardwaj — Tue, 23 Aug 2011 04:53:12 GMT

Hello all,

I have a staright table and in which I need to ignore the repeated combination of (Dept Id+Ord Id) if more than once. See below for more explanation.

Show count as '1' if it is a unique Dept Id and Ord Id. If Dept Id+Ord Id is repeating, then just put ‘1’ only for the first value and put ‘N/A’ for the remaining values.Please refer to the below attachment for more. Please let me know how we can implement this logic in the chart (straight table)?

Thanks in advance.

Cust ID	Dept ID	Ord Id	Sales(in $)	Count
			43000	6
1	A1	100	5000	1
2	A2	200	7000	1
3	B1	300	6000	1
4	B1	300	8000	N/A
5	B1	300	9000	N/A
6	B1	700	9000	1
7	C2	400	4000	1
8	C2	400	3000	N/A
9	D1	600	1000	1

Regards,

Sharma

Re: Ignoring repeating values in staright table

lironbaram — Tue, 23 Aug 2011 06:15:49 GMT

hei

try this one

hope its helps you

Ignoring repeating values in staright table

montubhardwaj — Tue, 23 Aug 2011 12:41:34 GMT

Hello Liron,

Your logic works fine in sample application but when I implemeneted the same in my application, it is not working as desired. Dont know where I am making the mistake

Re: Ignoring repeating values in staright table

lironbaram — Tue, 23 Aug 2011 12:51:09 GMT

hei

attach is an example pf calculating your logic in the script

may be you can use it

Ignoring repeating values in staright table

sridhar240784 — Tue, 23 Aug 2011 12:54:16 GMT

Sharma,

Could you post your sample application which will explain your problem in detail.

-Sridhar

Ignoring repeating values in staright table

montubhardwaj — Tue, 23 Aug 2011 15:10:08 GMT

HI Liron,

Thx for the response. Actually in my real report, I have many fields in the table(around 20). So does that mean I have to pull all the fields in order by clause to make it work ?

Re: Ignoring repeating values in staright table

lironbaram — Wed, 24 Aug 2011 07:12:12 GMT

you need to order only the fields that are relvant an you need sorted

for example if you have client name you do not need to sort it

can you post a sample data