topic two records with same values do not show twice in QlikView

two records with same values do not show twice

Anonymous — Fri, 06 May 2011 08:00:35 GMT

Good morning,

I kindly ask some help to solve the following issue.

I load some data and as you can see there are some values that appear twice

they are code1, 6, 40 and code2, 15, 50

I created some charts, see also attached file, and as you can see in the top one I do not know how to display all values:

Thank for helping.

Antonio

using v.10

two records with same values do not show twice

Fri, 06 May 2011 08:21:21 GMT

Hi,

Your expression should be Sum(Qty*Price) to get the correct output.

And Dimension with act according to the expression which you write. For example you may have two 6 and two 40 for Price and Qty, but qlikview will consider as only one when you write a expression like this Sum(Qty*Price)

Not sure how to add attachment to post

- Sridhar

two records with same values do not show twice

Anonymous — Fri, 06 May 2011 08:37:50 GMT

Dear Sridhar,

I have followed your suggestion and wrote the Expression labeled [Total Sell] equal to

=Sum(Qty*Price)

the total invoiced is correct but I cannot see the right quantities on the top chart. So from what you wrote it looks that QlikView will not allow me to show to records:

Thanks

Antonio

two records with same values do not show twice

Fri, 06 May 2011 08:51:56 GMT

Ya, You are correct. Since you are summing up the value, qlikview wont show as two rows. If you want to show as two values then row should have some unique values. You may create one more column in you create for generating row number and you could add this to your table as shoun below

Load *, Rowno() as row;
LOAD * Inline [
Code, Price, Qty
code1, 6, 40
code1, 6, 40
code1, 6, 200
code2, 15, 50
code2, 15, 50
code2, 15, 200
];

add this row column in table. This will sepearte the rows and show.

- Sridhar

Re: two records with same values do not show twice

Anonymous — Fri, 06 May 2011 09:07:34 GMT

Dear Sridhar,

I followed your suggestion and evething show as I wished:

thanks

Antonio

Re: two records with same values do not show twice

Fri, 06 May 2011 13:42:08 GMT

sridhar24784 wrote:
Not sure how to add attachment to post
- Sridhar

Sridhar,

Click the "Use advanced editor" to bring up the ability to add attachments. See the screenshot below:

two records with same values do not show twice

Thu, 26 May 2011 15:08:12 GMT

ho..!! OMG...!! i never knew this.Till now to add a attchment to my post, i use to post my content and go back to post and again 'Edit' the post to add my attachment . This 'Use Advance Editor' works well..!!

Thanks Jason (Sorry, i`m very late to respond to this post). You have really saved my time..!!!

- Sridhar