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
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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: 
Not applicable
‎2012-07-26 04:42 PM

Basic Expression

I have three fields, ShipmentID, OriginalStack, and FinalStack. I want my bar graph to show how many ShipmentID's were originally in a different stack than they ended up in (aka OriginalStack does not equal FinalStack).

The x-axis is Final Stack, and the y-axis is the number of shipments. If you look at the attached document, the bar graph is correct, except I don't want to show the ShipmentID's where the OriginalStack=FinalStack. Can anyone help me add this to my expressions?

QVCommunity.JPG

Labels (1)
Labels
Test.qvw
739 Views
0 Likes
2 Replies
MayilVahanan
MVP
MVP
‎2012-07-26 04:50 PM

HI,

     Check the attached file,Like this?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Test[1].qvw
662 Views
0 Likes
Not applicable
‎2012-07-26 06:00 PM
Author

In response to MayilVahanan

Not quite. I don't want the ones where the OriginalStack=FinalStack counted at all. There should be three bars for every FinalStack on the x-axis. I thought that the attached solution would work, but it didn't... Take a look.

Maybe something with my script is wrong? The if statement isn't even working (as you can see in the table).

Test.qvw
662 Views
0 Likes