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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RS251290
Contributor
Contributor
‎2020-05-27 12:28 AM

Replacing a Value with 'NA' in a pivot table

I want to replace a value and show is as NA in my Qliksense dashboard. The value is a result of calculation (Current year Sales / Previous Year Sales), as dimension we have other regions. We want to show other regions in the pivot table but it's value should appear as 'NA'. Also it should not affect the other values.

Can any one help me with that ?

727 Views
0 Likes
2 Replies
Lisa_P
Employee
Employee
‎2020-05-27 12:48 AM

Use expression something like this:

If(Region=[MyRegion], ([Current year Sales ]/ [Previous Year Sales]), 'NA')

718 Views
0 Likes
RS251290
Contributor
Contributor
‎2020-05-27 01:34 AM
Author

In response to Lisa_P

Are you suggesting i should group other regions as my regions ?

 

700 Views
0 Likes