Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dafnis14
Specialist
Specialist

Calculated dimension with Set analysis?

Hi All,

I have a table with different types of transactions of a financial document.

Each transaction has a key with the date of the first transaction and the document ID.

So when the user selects a certain date, all the transactions are linked by that key.

But, I would like to create a table where this key is ignored, and all the transactions are displayed according to their transaction dates. The  dimension is the document number.

My question is, how to create the calculated dimension, and  ignore the key in that table.

  Thanks!

4 Replies
MK_QSL
MVP
MVP

Kindly Provide Sample Data.... !

dafnis14
Specialist
Specialist
Author

Hi,

I would like to show all the transactions regardless of the field key shop & date.

This key is linked to a selection in the sheet, and I would like to ignore it in the table I described above.

thanks!

img.png

MK_QSL
MVP
MVP

Need base data in excel file to work...

sujeetsingh
Master III
Master III

Use nested iff.

I dont think it will work