Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Need to show actual and future data together

Hello Everyone,

Can anybody please help in this,

I am creating one chart, in one expression I need to use two sources.

Like for actual data I need to get from one source, for future data I need to get from another source. What to use in the expression. I am trying like If year<max(year), then source 1 if Year>max(year) then source 2, but not working.

Please help in that.

Thanks in advance

Tags (2)
6 Replies
Highlighted
Not applicable

Re: Need to show actual and future data together

Anything wrong in this expression,

=if(SegName='Name1' and DATE<=$(vToday),RevenueCY),RevenueLY)

i am getting only the value from else statement.

Thanks

Highlighted
Specialist
Specialist

Re: Need to show actual and future data together

The approach a lot of people use is to concatenate the two datasets together to create a single facts table. You can then create expressions on the same table.

Highlighted
Not applicable

Re: Need to show actual and future data together

Try this

=if(SegName='Name1' and DATE<=$(vToday),RevenueCY,RevenueLY)

I just removed the bracket after RevenueCY

Highlighted
Not applicable

Re: Need to show actual and future data together

Yes David,

I have combined fact table, with two data sets, i created expression on the same table, still it is having the problem

Highlighted
Not applicable

Re: Need to show actual and future data together

Hi Vidhya,

It is not working, still getting the Revenue LY value

Highlighted
Not applicable

Re: Need to show actual and future data together

Can any body please look into this and help,

is there any other way to show future and history data together.

Thanks