topic Re: Concatenation problem in QlikView

Concatenation problem

poonam_kulwal — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have 2 tables in my data mode.

Purchase Table

Product

StoreName

LastPurchaseDate

Sales Table

SalesID

StoreName

SalesDate

Product

I have concatenated these two tables with other tables in my data model.

Now on UI side, I have two pages

One shows information about Purchases in straight table.

Product

StoreName

LastPurchaseDate

Other page shows information about Sales in straight table. One SalesID can have multiple Products.

SalesID

StoreName

SalesDate

Product

My issue is, when I make any selection on first page and navigate to second page and make some more selections, all selections on first page get cleared off.

And when I make any selections on second page and go to first page and do selections on first page all selection on second page gets cleared off.

The reason behind this is I am concatenating two tables. Is there any way to solve this issue? I need to stick with concatenation. I can’t change my data model.

Appreciate any suggestions on this.

Thanks & Regards,

Poonam

Re: Concatenation problem

Anonymous — Mon, 15 May 2017 17:46:09 GMT

you could use a separate (inherited) alternate state for each sheet...

Re: Concatenation problem

ziadm — Mon, 15 May 2017 17:47:54 GMT

You should not concatenate the two Table. Your Sales is your Fact Table and Product is your dimension Table

You need to find a key to link Sales To Product Table and I think the the Field ProductNo is your Field

Also suggest to read this

Concatenate vs Link Table

Re: Concatenation problem

Digvijay_Singh — Mon, 15 May 2017 18:09:02 GMT

You got mulitple records for sales and purchases for a single product by the concatenation in the data model. So when you are making selection in the purchase record it will skip sales record and vice versa ( I assumed that you are making selection in straight table directly).

Since you don't want to change data model you need to decide on some workaround to handle this. What if you lock your straight tables and don't allow any selection and use product filter(list box) to make selections. I think when you make selections only through product drop down, it should show both sales and purchase records for the selected product. Not sure though, may be I am missing some facts

Re: Concatenation problem

poonam_kulwal — Tue, 16 May 2017 07:09:16 GMT

Hi,

Robin I cant use Alternate state. This will not help me to resolve my issue.

Though I used BookMork, but It will create problems for other tables.

Digvijay, My client wants selection on Straight table. On any selection of straight table they want to see corresponding details on rest of the other tabs.

Ziad, I have total 7 tables with Master Calendar. I have concatenate all tables and linked to Master calendar. I have no idea whether link table concept will work in my scenario.

What about Data Island? Could you guys feel if I go for Data Island then that will resolve this issue?

Appreciate you replay.

Thanks & Regards,

Poonam