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: 
Not applicable
‎2012-12-17 05:24 PM

Date Question

Why is it that when I remove a date dimension from my table, the expression shows a different number. Is my Data Model not working correctly? I dont' want to have the date in the table, as I just want to sum by Region.

Thanks,

Alex

Edit Text: So it has been modified some, now when I remove the two ID's Billtype and Project type. My numbers change from the correct values. What do I need to do to not make the values change when I remove those IDs?

Incorrect total without the BillType and PaProjectType

I'vprovided the qv and qvs.ScreenShot275.bmp 

Correct total with both billtype and paprojecttype.

ScreenShot274.bmp

Great Plains PSO Dashboard Sample.qvw
GP Dashboard Script.qvs
230 KB
481 Views
0 Likes
1 Reply
brindlogcool
Creator III
Creator III
‎2012-12-17 06:06 PM

Hi,

Could you please attach the sample file.

182 Views
0 Likes