topic Re: Straight Table help in QlikView

Straight Table help

Wed, 20 Aug 2014 10:13:34 GMT

Hi All,

I have two tables...first table have sum values for each field.

Table1:

PLANT	SOURCE_CD	RECEIPT_CNT	REQ_CNT	OTD_CNT	CYC_CNT	DAY_CNT	P5_CNT	HISTORY
A	100	42	0	0	21	52	60	HISTORY
B	101	0	21	14	34	0	45
C	102	11	41	35	47	1	0

If I click on PLANT A(HISTORY) I need to show new table with PLANT A related data where SOURCE_CD=100 from Tabl2 Data (Attached excel have data sheet)

PLANT A OUTPUT TABLE:

out put table:
METRIC	FW_VAL	MONTH_VAL	QTR_VALUE	YR_VAL
RECEIPT_CNT	5	19	66	645
REQ_CNT	66	87	132	525
OTD_CNT	0	0	0	25
CYC_CNT	14	25	28	54
DAY_CNT	16	103	135	306
P5_CNT	58	68	95	108
Result table data where SOURCE_CD=100

table2 Data table:

MSR_ID	SOURCE_CD	FW_VAL	MONTH_VAL	QTR_VALUE	YR_VAL
1001	100	0	7	28	320
1001	100	5	12	38	325
1002	100	8	22	45	315
1002	100	58	65	87	210
1003	100	0	0	0	25
1004	100	14	25	28	54
1005	100	15	98	106	250
1005	100	1	5	19	56
1009	100	58	68	95	108
1001	101	0	0	7	56
1002	101	0	0	2	54
1002	101	5	15	35	212
1002	101	2	45	56	187
1003	101	0	10	12	25
1004	101	14	25	28	54
1005	101	15	98	106	250
1005	101	1	5	19	56
1009	101	0	45	95	100

I have attached the same ...any suggestions should appreciate.

Thanks

Re: Straight Table help

Gysbert_Wassenaar — Wed, 20 Aug 2014 10:32:52 GMT

See attached qvw.

Re: Straight Table help

Wed, 20 Aug 2014 11:21:09 GMT

Thx Gysbert,

Result Table looks good....but we have missed sum of data in plant table I would like to sum the each field value in PLANT table as well...seems it was missed.

Thanku

Re: Straight Table help

Gysbert_Wassenaar — Wed, 20 Aug 2014 11:28:46 GMT

Then enable them on the Expressions tab by setting the Total Mode to Expression Total.

Re: Re: Straight Table help

Wed, 20 Aug 2014 11:37:56 GMT

No I didnt not successed ....getting error in expression like field missing ,see the attached image.

Thanku

Re: Re: Re: Straight Table help

Gysbert_Wassenaar — Wed, 20 Aug 2014 11:47:41 GMT

Ah, that. See attached updated qvw.

Re: Re: Straight Table help

Wed, 20 Aug 2014 11:58:44 GMT

Gysbert..I did not see updated data...still same issue in qvw.seems you for got add updated one?

Plant table have 0 for all expressions.

Thanks

Re: Re: Straight Table help

Gysbert_Wassenaar — Wed, 20 Aug 2014 12:07:22 GMT

If you still see 0 for all expressions in the Plant table then you're looking at the wrong qvw document.

Delete all .qvw files with the name comm130076.qvw. Then redownload the example from my previous post. That will make sure you will be looking at the last version.

Re: Re: Straight Table help

Wed, 20 Aug 2014 13:02:52 GMT

Thanku Gysbert ..its good