topic Re: Table with a data set in QlikView

Table with a data set

Anonymous — Fri, 12 Feb 2016 10:54:08 GMT

Hello everybody,

I have a problem and I don't know the solution. I like to do a simple table with a ID and other calculates

ID Sum(field1) sum(field2)

I have many ID but I like to have only a set of these, for example

ID sum(field1)

1 1000

2 3000

3 4000

4 1000

I like what my table shows ID = 2 and 3. I would like the next table:

ID sum(filed1)

2 3000

3 4000

In my real example, I make a set : only({(<field2 = $::field2>) - <IDA= $::IDA> * (<field1 = $::field1>)}ID)

but I'm not as to do what my table only shows the IDs of the set

¿How can I have my table?

Sorry for my bad English

Regards

Re: Table with a data set

sunny_talwar — Fri, 12 Feb 2016 10:56:19 GMT

Can you share a sample app or data with expected output?

Re: Table with a data set

kaushiknsolanki — Fri, 12 Feb 2016 10:56:36 GMT

Hi,

All you have to do is this.

Create chart with ID as dimension

and

Sum({<ID = {"2","3"}>}Field1)

as Expression.

Regards,

Kaushik Solanki

Re: Table with a data set

sunny_talwar — Fri, 12 Feb 2016 10:58:29 GMT

Hi Kaushik,

Doesn't it seem based on his current expression that he want the output to be based on selections? You might be totally right, but I am not sure what exactly he is looking for.

Re: Table with a data set

kaushiknsolanki — Fri, 12 Feb 2016 11:01:42 GMT

You are right Sunny.

I just gave the expression for him to understand, how subset of the data can be obtained easily.

If he needs based on selection, then I would like him to try his hands first before asking the question, because its simple logic...let him try and in any case community is always available for him.

Regards,

Kaushik Solanki

Re: Table with a data set

Anonymous — Fri, 12 Feb 2016 11:01:50 GMT

Hello,

My problem isn't as easy. In my problem real, I don't know the IDs that's why I make a set. I have the set and I should do my table with this

Regards

Re: Table with a data set

sunny_talwar — Fri, 12 Feb 2016 11:06:35 GMT

Re: Table with a data set

luciancotea — Fri, 12 Feb 2016 11:10:01 GMT

Are you trying to compare two sets of ID using Alternate States?

Re: Table with a data set

kaushiknsolanki — Fri, 12 Feb 2016 11:10:15 GMT

Dear Jonay,

Can you please post the sample application and explain your problem in detail, like what you have and what you need as output along with the logic.

Regards,

Kaushik Solanki

Re: Table with a data set

Anonymous — Fri, 12 Feb 2016 11:24:40 GMT

Hello everybody,

I am trying make a table with some values of ID. I need to show only some values. I add a example

It isn't my real example, but I hope to explain my problem

I have 3 fields, ID,A and B. I need to show Only({<A=-{"x"}>* <B=-{"x"}>}ID). I would like to show only ID = 3,4

My table will be the next:

ID sum(valor)

3 300

4 400

¿Do we understand me?

Regards

Re: Table with a data set

kaushiknsolanki — Fri, 12 Feb 2016 11:26:52 GMT

Hi Jonay,

Sorry I am still confused on what you need.

It would be great if you can create some sample data ans share with us.

Regards,

Kaushik Solanki

Re: Table with a data set

Anonymous — Fri, 12 Feb 2016 11:37:15 GMT

Hi!

If I make the tabla, It will be

ID sum(valor)

1 100

2 200

3 300

4 400

5 500

6 600

But I need to show, the Ids that is in the set

The resulting table what I hope is

ID sum(valor)

3 300

4 400

I don't like to show all ids. I like to show only the Ids of set

Regards

Re: Table with a data set

kaushiknsolanki — Fri, 12 Feb 2016 11:42:12 GMT

Hi Jonay,

I understood that you want to show some of the ID's from the entire list.

Now tell me on what basis you will select which ID's to be shown.

Do you know that you have to always show only ID 3 and 4 or is it something depended on some values of some other field?

Regards,

Kaushik Solanki

Re: Table with a data set

sunny_talwar — Fri, 12 Feb 2016 11:47:44 GMT

May be this:

sum({<A=-{"x"}>* <B=-{"x"}>}valor)

Re: Table with a data set

Anonymous — Fri, 12 Feb 2016 12:31:00 GMT

Hi Kaushik,

I shouldn't show only ID 3 and 4, It depends. I did this easy example for to explain my problem. I would like what have been selected the values of the set. Maybe ID = 3,4 or ID 1,2, or other. It depends the others condition. If I make a set , ¿is possible to show the ids of the set only?

Regards

Re: Table with a data set

kaushiknsolanki — Fri, 12 Feb 2016 12:35:52 GMT

Dear Jonay,

The expression which is used in the example I gave is based on the Set only, but on what basis you will defind the set is what I am looking.

You said that "Based on Selection", So do you mean that Whatever ID's are selected by user should only be visible?

Regards,

Kaushik Solanki

Re: Table with a data set

Anonymous — Fri, 12 Feb 2016 12:47:27 GMT

Hi!

The user don't do selection. The file is reload automatically and I create a report. I have some tables and It share a field ID. I make a set what select ID These Ids are in both tables.

In the easy example:

Only({<A=-{"x"}>* <B=-{"x"}>}ID)

In the real example, It is more difficult, but I have the Ids. I make a set and I need what this set will be the values showed

Regards