topic Transform Table Peek() and Previous() Help........ in QlikView

Transform Table Peek() and Previous() Help........

prees959 — Sat, 16 Nov 2024 03:37:37 GMT

Hi,

Im trying to transform a table from :

ID	TimeStamp	Page
76339	09/10/2018 15:34:44	Costs
76339	09/10/2018 15:34:57	Leads
76339	09/10/2018 15:40:35	Customers
76339	09/10/2018 15:44:28	Costs
76339	09/10/2018 15:44:34	Leads
76339	09/10/2018 15:45:15	Customers

To show the flow of pages accessed as :

ID	Page1	Page2	Page3	Page4	Page5	Page6
76339	Costs	Leads	Customers	Costs	Leads	Customers

... and so on.

There may be far more page selections per ID but can would the code be able to dynamically create the required output regardless of the Pages?

Also, the table is ordered by ID and Timestamp when loaded.

many thanks and any help is greatly appreciated.

Phil

Re: Transform Table Peek() and Previous() Help........

marcus_sommer — Thu, 09 May 2019 15:04:25 GMT

You could try to adapt a generic load approach for it whereby your page-values aren't unique in regard to the ID so that you may need to create an extra counter-field for it.

I don't know your requirement but I think I would rather use just an aggregation like:

concat(Page, ' ==> ', TimeStamp)

which will show the evolution within a single field respectively UI expression.

- Marcus

Re: Transform Table Peek() and Previous() Help........

prees959 — Thu, 09 May 2019 18:56:53 GMT

Hi @marcus_sommer

Thanks for your reply. I'm not sure I understand your solution.

I'm hoping to create a table from my main resident table with ID as the Key field in the format I've described. I will be able to use these Page fields as Dimensions that can be selected for further analysis.

Many thanks,

Phil