Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.