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: 
Not applicable

Display All Data when Modifier is a Dimension

Hi,

I am looking to display all the data that there is, currently when I select a particular DATA(my date field) only then I am able to populate the columns.

For example

I want to see a table like this

DATASUM(VALOARE)SUM(<2 day before> VALOARE)SUM({<1 day Before>} VALOARE)
51600
8/19/201112000
8/20/20111260120
8/21/2011132120126
8/22/2011138126132

Instead I am only seeing data when I click on a particular DATA date.

This is what I see when I click on DATA=8//22/2011

DATASUM(VALOARE)SUM(<2 day before> VALOARE)SUM({<1 day Before>} VALOARE)
138126132
8/20/201101260
8/21/201100132
8/22/201113800

Thanks for the help in advance.

Ajit

5 Replies
Not applicable
Author

try above( sum( VALOARE), 2 ) and above( sum( VALOARE), 1 )

Not applicable
Author

This is a simplified veiw of the sheet I actually have, using above solves this problem but doesnt work for my other table where there are more complications.

Do you know of a solution using Set Theory ??

Thanks anyways.

Not applicable
Author

Hi,

When we are selecting any date from datanum field the results are showing up correctly.. it might be the case that due some inconsistency of data the results coming yp are not proper... kindly convert your datanum field into date and then see the result..

Not applicable
Author

sorry

Not applicable
Author

I am not sure you got my question, I am able to correctly populate the sheet when I select a particular DATA point. I want to populate the complete sheet. Hypotheticlly if I have 20 DATA points then I want a 20x3 matrix that is completely populated not a 3x3 matrix when I select a DATA point.

Thanks