topic Re: How to show a table(not pivot) with certain data in QlikView

How to show a table(not pivot) with certain data

ecabanas — Tue, 04 Feb 2014 08:55:30 GMT

Hi I have the follong data in a table chart:

ITEMID	ITEMNAME	DATEFINANCIAL_LINE	INVENTTRANSID	TRANSTYPE	INVENT_QTY	Cost
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	02/01/2014	00981599_103	0	-1	-2,27
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	08/01/2014	00994254_103	5	-5	-11,35
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	10/01/2014	00995839_103	3	6	13,62
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	18/01/2014	01017648_103	0	-1	-2,27
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	27/01/2014	01036417_103	5	-5	-11,35
10361283	TRINCHADO DE CARLIT DE LA CERDAÑA	28/01/2014	01038177_103	3	6	13,62

But I only want to show the lines with TRANSTYPE = 5

I can not use a list box 🙂

Many thank's

Eduard

Re: How to show a table(not pivot) with certain data

Tue, 04 Feb 2014 09:14:12 GMT

in your expression write like this

sum({<TRANSTYPE={5}>}cost)

or please post your sample app. make it easy to clarify your ques

Re: How to show a table(not pivot) with certain data

senpradip007 — Tue, 04 Feb 2014 09:16:53 GMT

try this in expression:

Sum({<TRANSTYPE = {5}>}INVENT_QTY)

and

Sum({<TRANSTYPE = {5}>}Cost)

Hope it helps you.

Regards

Re: How to show a table(not pivot) with certain data

ecabanas — Tue, 04 Feb 2014 09:22:10 GMT

Hi PS

Thank's for your answer, but I want to see all the lines, not the sum.

This is a Scarp report, and there are two tables, one with the "SUM" and the other is the complete list of scrap units.

many thank's

Re: How to show a table(not pivot) with certain data

Tue, 04 Feb 2014 09:24:28 GMT

Can you post your sample

Re: How to show a table(not pivot) with certain data

Tue, 04 Feb 2014 09:28:47 GMT

PFA

Re: Re: How to show a table(not pivot) with certain data

senpradip007 — Tue, 04 Feb 2014 09:32:06 GMT

As per my understanding you want the line which contains TRANSTYPE = 5 without any sum.

Re: How to show a table(not pivot) with certain data

Gysbert_Wassenaar — Tue, 04 Feb 2014 09:34:25 GMT

You can select transtype 5 in a table box as well.

But if you want to hardcode the selection (not recommended) you need a straight table with at least one expression. For example sum({<TRANSTYPE={5}>} Cost).

Re: Re: How to show a table(not pivot) with certain data

ecabanas — Tue, 04 Feb 2014 09:53:40 GMT

Hi,

here you have an example

Re: Re: Re: How to show a table(not pivot) with certain data

senpradip007 — Tue, 04 Feb 2014 10:17:45 GMT

Hi Edu.

You can't this features in Tablebox. To achieve this you have to go with straight table.

Re: How to show a table(not pivot) with certain data

Tue, 04 Feb 2014 10:21:16 GMT

Hi Eduard.. What is Mr Pradip said its right there is no option in table box better you go to straight table

Re: How to show a table(not pivot) with certain data

Tue, 04 Feb 2014 10:23:36 GMT

PFA hope this will helps you

Re: Re: Re: How to show a table(not pivot) with certain data

ecabanas — Tue, 04 Feb 2014 10:31:36 GMT

Hi guys,

Yes I understand, but with the example returned by Pradip in the straight table you do a SUM, but i need a list of transactions with TRANSTYPE 5, not a SUM!!! I need a table with the summation and other table explaining what is this summation.

Many many thank's guys

Re: How to show a table(not pivot) with certain data

ecabanas — Tue, 04 Feb 2014 10:44:34 GMT

WOW!!!!! Applause!!!!!

Many thank's Nirmal, and many thank's all guys!!!

Re: Re: Re: How to show a table(not pivot) with certain data

Gysbert_Wassenaar — Tue, 04 Feb 2014 10:45:03 GMT

That doesn't matter as long as you add all the dimensions that make the record unique to the straight table. You'll get a sum of an individual record. sum(10) will still be 10.