topic Re: How to see repeated values in QlikView objects? in QlikView

How to see repeated values in QlikView objects?

Thu, 28 Mar 2013 12:05:11 GMT

Hi,

I would like to see all repeatable values from my source table.

I will show my example now:

I have some source table (in my LOAD command), for example ABC,

which has three columns A, B, and C. And there are 4 rows in this ABC table:

A	B	C
a1	b1	10
a2	b2	20
a3	b3	30
a3	b3	30

I would like to see all four rows is some of QlikView objects.

I think that using of LIST BOX is not suitable for this purpose because LIST BOX is BY DEFINITION only for DISTINCT VALUES.

So for example LIST BOX for column A will show only three values (a1, a2 and a3), not four values (a1, a2, a3 and a4).

So I thought the right object for this purpose can be STRAIGHT TABLE or TABLE BOX. But both of them

display only three rows again, that is the first, the second and the third of ABC table, the fourth row is not displayed.

So my question souds: Is it possible ANY of QlikView object configure in it PPROPERTIES so,

that I can see ALL rows from my source table, although the third and fourth row contents identical values?

Thank you very much in advance,

Mirek

Re: How to see repeated values in QlikView objects?

Thu, 28 Mar 2013 12:13:10 GMT

Hi,

yes u can see all repeated values in straight table through below procedure

1.) Add dimension A, C

2.)In Presentation tab Select C column and click on Hide checkbox

3.)in Presentation tab uncheck "Supress zero-values"

hope it helps

Best of luck

Re: How to see repeated values in QlikView objects?

Thu, 28 Mar 2013 12:27:08 GMT

Seems like the simple solution is to bring in a rownum() on the load process. That way you could show all columns because there is a unique key.

Re: How to see repeated values in QlikView objects?

Thu, 28 Mar 2013 12:46:09 GMT

Hi Satish venkat,

Than you for your advice, but I have reproduced your advice exactly

and the result contents only one column, that is A, and below it only three values: a1, a2, a3.

So there are not other two columns (B and C) and there are not fourth rows, but only three.

Mirek

Re: How to see repeated values in QlikView objects?

Thu, 28 Mar 2013 12:52:20 GMT

Hi,

FYI the attached app and let me know that it gives your result.

Best of luck

Re: How to see repeated values in QlikView objects?

Thu, 28 Mar 2013 13:18:00 GMT

Hi, I have look at your design, but:

1) In LOAD statement there are the third and fourth row DIFFERENT, not the same like in my ABC table.

2) Your Straight table was damaged on the sheet, it has NOW rows.

So I have corrected the LOAD statement: the fourth row is now the same like the third one.

And then I have tried to reconstruct your Straight table, but then it contents only three rows.

So I tried next step:

1) I have tried apply the brentski design

(to add RowNo() function as the fourth column into LOAD statement).

2) Then I have defined Straight table with 4 dimension (A, B, C and RowNo() column)

and then I have used half of your suggestion: I have choose in Presentation tab

the RowNo() column and then I clicked on Hide checkbox for it.

(I did not change "Supress zero-values" value.)

The result: GREAT! The Straight table now shows 4 rows and A, B and C columns!

So thank you very much for your advice which I used with combination of brentski advice.

Mirek