Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist II
Specialist II

Crosstable Expression

I have a crosstable where my requirement is to only show discrepancies (differences) in the chart. The duplicate can be on any of the dimensions after DESCRIPTION.

For example: since the ORDERABLE here is the same in both ECISA and CAREB for this DESCRIPTION, I would not want to show it on this chart:

8-21-2017 1-31-07 PM.jpg

1 Solution

Accepted Solutions
sunny_talwar

May be this

If(Count(DOMAIN) = Before(Count(DOMAIN)) or Count(DOMAIN) = After(Count(DOMAIN)), Null(), Count(DOMAIN))

View solution in original post

5 Replies
Anil_Babu_Samineni

Look here?

Work around, May possible in script for 3rd expression then Use flag to exclude with in the Count statement

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sunny_talwar

May be this

If(Count(DOMAIN) = Before(Count(DOMAIN)) or Count(DOMAIN) = After(Count(DOMAIN)), Null(), Count(DOMAIN))

View solution in original post

cbaqir
Specialist II
Specialist II
Author

I wish I could have thought of this... but is it just looking at the preceding row? What if it's not exactly in that order?

sunny_talwar

Not the preceding row... it is looking in preceding column and proceeding column

sunny_talwar

Check out After/Before here:

Missing Manual - Before() and After()