topic Re: Please help with expression in QlikView

Please help with expression

Mon, 06 Oct 2014 05:34:27 GMT

Hello Everyone,

I have measure 1, measure 2

Measure 1 having only history, measure 2 having history and future.

if i select the year 2014, the data should show history+future( here i should not take history from measure 2)

if i select future that is from measure2

if i select history (Year or month or quarter ) it should take from history

data should not effect if i select any date or week

Please help to write the expression, my dimension is month

Thanks

ashfaq_haseeb — Mon, 06 Oct 2014 05:36:35 GMT

Hi,

Can you come up with sample data and expected output?

Regards

ASHFAQ

Mon, 06 Oct 2014 06:20:27 GMT

Hello Mohammed,

Please find the attached excel and qvd,

it has two sources,

source1 having only history

source 2 having history and future.

if i select 2013 the data should show from source 1

if i select 2014 the data should show source1(history till sep end)+source2(only future from source2).

if i select 2015 only source 2.

three conditions in one expression. Please look into this

Thanks in advance

ashfaq_haseeb — Mon, 06 Oct 2014 07:03:40 GMT

Hi,

you have to play with =MonthName(today()) function and flags

Regards

ASHFAQ