Skip to main content

Qlik

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: 
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 ?

407 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')

398 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 ?

 

380 Views
0 Likes