Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
rename the comon fields.
qty as crop_qty
cost as cost_qty
qty as buy_qty
cost as buy_qty
use all the fields when combining data.
Hi,
Try this,
Using qualify statement in script , you can able to display the raw data separately without map to the another table, but make sure that, you don't want to combine the tables for further.
Qualify B;
Load A,B from x.csv;
Load A,B from y.csv;
The two tables x.csv and y.csv are joined only on A. Three fields will result: A, x.B, y.B.
Hope it helps
Hi, I will have two tabs one will show pivot combinign summary of both the tables. and another tab will just display raw data extract of all fields.
Right now on Table Box properties I have used "calclulation condiion tab" as one table is corresponding to Fruit and another to Crops.
Ofcourse when no type is selcted both tables are empty stating 'Calculation condition unfulfilled'.
I am not sure if renaming of fields will work as common field names help summarizing pivot view if two tables.
I will try to use qualify solution.
Qualify Will do exactly what I have told, but for all fields and automatically.
Maybe you should concatenate both tables and create a Field called DATAMART where you could put the type (CROP, SELL).
When you want only one to be displayed, select the DM you want or maybe use the set analysis on the formulas
Enviada em: segunda-feira, 2 de julho de 2012 17:26
Para: Adriano Weihmayer Almeida
Assunto: - Re: Raw data table display
QlikCommunity<http://community.qlik.com/index.jspa>
We would appreciate your participation in 'The BI Survey 11: The Customer Verdict'<https://digiumenterprise.com/answer?link=931-APTZARSW> the world's largest survey of business intelligence (BI) and performance management (PM) users.
Re: Raw data table display
created by andrepeter<http://community.qlik.com/people/andrepeter> in New to QlikView - View the full discussion<http://community.qlik.com/message/233819#233819>
Created tableview from Chart type box and used set analysis method.
Reason I used Set analysis is we have multiple DM type (if i can borrow variable name from earlier post).
Now as of now it seems to be working. Thanks alot for the help.
==================================================================================
Lastest update- still facing some problems with two raw data tables. Some times they are becoming detached , hence don't take controls from slected listbox, didn't know it was possible. WIll update solution with correct method once I have solved the issue.
Any idea how to use GetFieldSelections in set analysis.
I want to use setanalysis similar to below example
= If(GetSelectedCount(Type-Listbox) = 0, Count({$<Type={Rice,Wheat,Oat,Barley}>},Type),
Count({$<Type={GetFieldSelections(Type-Listbox)}>},Type))
But this bold part doesn't work because i can't include GerFieldSelections in Set Analysis.
Thanks in advance for your help.
Hi, Try joining the two table using an artifical filed like Source in the file attached. This allows you to use the entier data set accross both tables and also lets you mantain the integrety of the individual tables. Best of luck! Regards Rahul L
Hi,
by your bold text, it seems you want to count the amount of types not selected.
If this is the case:
Create Text boxes:
='Total: ' & count({ 1<Name={'*'}> } distinct Name)
='Selected: '& getSelectedCount(Name)
= 'Not Selected: ' & (count({ 1<Name={'*'}> } distinct Name) - getSelectedCount(Name))
to use functions on set analysis, put the function between $(= )
ex:
count the number of depts that a single employee is manager
count( { < Manager={ '=Only(Employee)' } > } Dept)
Thanks a lot for all the responses.
Sorry if I didn't put question clearly earlier.
I was trying to display taw data for both the tables Fruits and Crops in two seperate raw tables on qlikview dashboard.
In my inline data I added one extra field called Type. Type has value as 'Fruit' for fruits tables and 'Crop' for Crop Table.
I did that using set analysis because I wanted one table to display "Fruit" data and another to display "Crop".
For e.g. =COUNT({$<[Type] ={Fruit}>} Type)
=COUNT({$<[Type] ={Crop}>} Type)
Now both tables are segregated and display only data for Fruits and Crops respectively.
Now if I put a listbox with value of "Type". Irrepsective of selction of listbox rawtable's value doesn't change.
For e.g. if I select only Type as "Fruit" , Crop Raw table doesn't become empty but continues showing Crop raw data.
If I add filters for rest of the fields, it works perfectly fine. But only Type listbox filter is ineefcetive because it is in set analysis.
Hence I was trying to do similar to below solution but it doesn't work
= If(GetSelectedCount(Type) = 0, Count({$<Type={Crop}>},Type), Count
Count({$<Type={GetFieldSelections(Type)}>},Type)).
Bold part in above equation never works. It can't get list of selected fields from list box. My expexctation was once it finds selected type is Fruit in listbox, above equeation will ensure nothing to be displayed on Crop raw table.
At present I have solved it by adding extra field "Type_1"(duplicate of Type) in my set analysis and keeping listbox for field "Type". It works.
For e.g. =COUNT({$<[Type_1] ={Fruit}>} Type_1)
=COUNT({$<[Type_1] ={Crop}>} Type_1)
But I think adding extra field is not good solution. Any suggestion is appreciated.