topic Re: Scenario Help in QlikView

Scenario Help

abhaysingh — Thu, 23 Apr 2015 09:56:20 GMT

Hi all,

i have several product type in a table which are in field form(i.e. Prod1, Prod2, Prod3, Prod4, Prod5, Prod6 and so on).. i want to put it in single field called Product Category..How i can do this?

Thanks in Advance ...

Re: Scenario Help

stigchel — Thu, 23 Apr 2015 10:06:42 GMT

You can use a crosstable load, see example attached

Re: Scenario Help

abhaysingh — Thu, 23 Apr 2015 10:58:27 GMT

when i am using cross table my result set is getting increased..what to do in that case..

Re: Scenario Help

stigchel — Thu, 23 Apr 2015 11:19:34 GMT

What do you mean by result set getting increased, can you give an example demonstrating the problem?

Re: Scenario Help

Thu, 23 Apr 2015 11:20:21 GMT

Hi Abhay

Can you please provide some practical sample or idea how do you required to implement the feature. you mean to say when you select the product it will display the all Product category is that what you required.

Thanks

Re: Scenario Help

abhaysingh — Thu, 23 Apr 2015 11:51:27 GMT

Hi Piet Hein,

i am simply counting the total product which are in numeric form.. and suppose total count in 20000 than after using cross table it is giving me 120000, this i mean to say my result set is increasing

Re: Scenario Help

abhaysingh — Thu, 23 Apr 2015 11:54:55 GMT

i have i column which contain the Total product count.. and product data is in form of multiple column like prod1 is column 1 and product 2 is column 2 and so on... i m using cross table with syntax.. Crosstable(Productname, data, Number).. but when i am simply doing count of Total Product..it is giving me 120000 intead of 2000

Re: Scenario Help

stigchel — Thu, 23 Apr 2015 12:14:24 GMT

Try with

=Count(DISTINCT Productname)

Re: Scenario Help

jonathandienst — Thu, 23 Apr 2015 13:27:47 GMT

Well that's correct and expected. The Crosstable load will give one row per value. If you have a 1000 rows with 6 values on each row and you crosstable that, each source row will result in 6 target rows, so you will get 6000 rows.

Crosstable is unpacking the data, although the table has more rows, it is much more efficient.

HTH

Jonathan