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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
uacg0009
Partner - Specialist
Partner - Specialist

Dimensions - why - same conditions make different results

Hi all,

Sorry at first I need to say maybe this problem is a little abstract, because I can't do an example for this.

Problem is :

I have a chart and there are two dimensions in this chart.

situation 1:

the two dimensions are:

1:1.JPG.jpg

2:2.JPG.jpg

And result is :

3.JPG.jpg

what I want to say is that you can see there are some data in column Y-1 >= column Y-2, like 2012-03-23>2009-11-07.

BUT if I use these two dimensions, the result is different:

1:4.JPG.jpg

2:2.JPG.jpg

the second one don't change, in the first formula, I want to show the count item cat1 but not period date dt.

The result is :

5.JPG.jpg

Now I think you can see the difference, what I want to say is there is no data(period date dt) in column Y-1 > column Y-2.

I don't know why? the data in column Y-1 now all less than 2012-02-10. ( 2012-02-10 is the max period date dt of column Y-2)

why I do this change in the first dimension will affect the nearly all results of column Y-1. All data in column Y-1 > Y-2 are gone.

Is there a method to make the column Y-1  like before and also calculate the count item cat1?

I hope I have clarified what I want and if you have any questions pls tell me.

Thank you so much!

Labels (1)
0 Replies