Raw data table display

[#1]

Hi, I have below two tables which I am using to anaylze.

Name	Cost per Lb in $.	Qty	Expiry Date	Buy Date	Buyer
Mango	10	1000	04-Aug-2012	04-Jun-2012	PP
Oranges	5	2000	05-Jul-2012	04-May-2012	AA

Crop	Cost per Lb $	Qty	Reserved for next year	Producer	Country of Origin
Rice	5	4000	400	A	China
Wheat	4	1000	100	B	USA
Oat	5	2000	200	C	Canada
Barley	6	1000	100	D	Argentina

I have created pivot cobinign aboveboth tables for my analysis (Fruit as well as Crops).

But when I want to display raw data seperately for both the tables, QV is combining data from both tables because some fields *(like COst, QTY) are common.

Any idea how easy to segreatge these data without using list box option?

[#2 · Accepted solution]

Qlikview is working EXACTLY as expected. As you have created 2 tables stating what type you want, it will ignore the selection you did on type. The table Will always show up no matter what. This is what you programmed.

If sometimes you want one and sometimes you want others and sometimes you want both, why not have only 1 table with the Field type on it and turn on the dropdown feature for this Field? Than you Will be able to filter inside the tabel what set of data you want to see.

If you want to compare, you may have a look at the new feature on Qlikview 11, called Alternate States.

Esta mensagem (incluíndo qualquer anexo) é dirigida apenas para o uso do indivíduo ou da entidade a qual está endereçada e pode conter informações privadas, proprietárias, privilegiadas, confidenciais que podem servir como evidências sob as leis aplicáveis ou em processos judiciais.

Caso você não seja o destinatário pretendido, você está aqui notificado que qualquer uso, disseminação, distribuição, ou cópia dessa comunicação é estritamente proibida. Se você recebeu essa comunicação por engano, notifique-nos imediatamente por telefone, e destrua essa mensagem se estiver impressa ou (ii) exclua imediatamente essa mensagem se esta for uma comunicação eletrônica.

Obrigado.

This message (including any attachments) is intended only for the use of the individual or entity to which it is addressed and may contain information that is non-public, proprietary, privileged, confidential, and exempt from disclosure under applicable law or may constitute as attorney work product.

If you are not the intended recipient, you are hereby notified that any use, dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, notify us immediately by telephone and destroy this message if this is printed or (ii) delete this message immediately if this is an electronic communication.

Thank you.

[#3]

Hi Adriano,

Thanks a lot for the response, as you confirmed my theory in your response.

Hence in worst case if I need to show two diffrent raw tables with common keys, I will try to duplicate key field for set analysis.

Below statement was really helpful.

=====================================================================================

Qlikview is working EXACTLY as expected. As you have created 2 tables stating what type you want, it will ignore the selection you did on type. The table Will always show up no matter what. This is what you programmed.

=====================================================================================

[#4]

Probably i am missing someting but why do you not use Type as dimension?

[#5]

Re: Raw data table display  

Probably i am missing someting but why do you not use Type as dimension?

===============================================================

It was already part of dimension. But this isssue si reoslved for me now.