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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
risabhroy_03
Partner - Creator II
Partner - Creator II

Table visualization

I am using the below expression in my table

if([Table Source]=('WHINH301') and ("T$LTRL"=1) and ((len(trim("T$BOLA"))>0)),Sum({<[Ship_Date_GMT_Updated]={"<=$(vLastmonthdate)"},[Arrive_Date_GMT_Updated]={">$(vLastmonthdate)"}>} Quantity)
,if([Table Source]=('WHINH301') and ("T$LTRL"=2) and ((len(trim("T$BOLA"))>0)),Sum({<[Ship_Date_GMT_Updated]={"<=$(vLastmonthdate)"}>} Quantity)
))

But when I remove a field named [SHID] my Quantity value changes, even though I haven't used [SHID] on my front end.

Can anyone tell why?

3 Replies
vinieme12
Champion III
Champion III

Where are you removing [SHID] from, is it a dimension in your chart? a filter applied? 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
risabhroy_03
Partner - Creator II
Partner - Creator II
Author

I am removing SHID from my table visualization.

Yes, it is a dimension in my chart.

vinieme12
Champion III
Champion III

that means your values are simply aggregating at a different level now,

 

also do not use keyfields in your charts

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.