Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How can I compare records from same dataset

I want to compare shopping habits of two customers. A simple data sample data is laid-out

MonthCustomerIdProduct CategorySub CategoryAmount Spend
Jan1EntertainmentMusic50
Jan1EntertainmentGames50
Jan1ElectronicsMobile500
Jan1ElectronicsHome200
Jan1BooksAudio50
Jan1EntertainmentMusic20
Feb2EntertainmentMusic20
Jan2ElectronicsHome300
Jan2BooksAudio50
Jan2BooksHard Copy20
Jan2EntertainmentMusic20
Feb2BooksHard Copy100
Feb2EntertainmentGames100
Jan3EntertainmentMusic150
Feb3EntertainmentGames10

And I want to create a view where I can compare two customers (for a period of time). The view would look something like

Thanks

14 Replies
Not applicable
Author

you rock !

Not applicable
Author

Petter,

how do I 'escape' a list of dates i.e.

TxnDate={$(=Concat(DISTINCT TxnDate1,','))}


I tried

TxnDate={$(=Concat(DISTINCT TxnDate1,'","'))}

and

TxnDate={"$(=Concat(DISTINCT TxnDate1,','))"}


but they don't seem to work

Not applicable
Author

found it

for posterity, you use 'Chr' function. I was messing up the braces.

TxnDate={$(=Concat(DISTINCT Chr(39)&TxnDate1&Chr(39),','))}

CelinaBrenna
Contributor
Contributor

If you are looking for a free music app that has hundreds of mp3 songs then Sonnerie 2022 

BeverlyKayla
Contributor
Contributor

Per scaricare le suoneria telefono, rimani qui con noi.