topic Re: Data not visible for 2017 in QlikView

Data not visible for 2017

dolly777 — Mon, 09 Jan 2017 07:38:51 GMT

Hi All,

Current year data not visible in my dash board could you Please suggest?

Please find screen shot.

Re: Data not visible for 2017

Mon, 09 Jan 2017 07:51:31 GMT

Hi Nirmala

Do you have any data in your application for 2017?

What does your expressions look like? (Might be hard coded to 2016?)

Please provide a bit more information regarding your error / problem.

Kind Regards

Re: Data not visible for 2017

Mon, 09 Jan 2017 08:01:24 GMT

Hi Nirmala

Does you data for 2017 dates if so it might show

Re: Data not visible for 2017

Anonymous — Mon, 09 Jan 2017 08:04:26 GMT

Hi,

Check the data format for those with 2017, the year to be 2017, if you are loading from xls or different source than 2016.

Check first if you have in the fact tables values, maybe a field that connects table is not correct set.

Best regards,

Cosmina

Re: Data not visible for 2017

dolly777 — Mon, 09 Jan 2017 08:11:14 GMT

Hi Jandre,

Please find Expression 4 chart

first chart exp is

=SUM(

%measures={'overall_capex','overall_pure','overall_e_catalogue','overall_no_po','overall_nb_orders_rto'},

%selection_type={'selective'},

%year={'$(=MAX(%year))'}

>}values

)/1000000

--------------------------------------------

=SUM(

%measures={'overall_capex','overall_pure','overall_e_catalogue','overall_nb_orders_rto','overall_no_po'},

%selection_type={'selective'},

%year={'$(=MAX(%year))'}

>}values

)/SUM(TOTAL

%measures={'overall_capex','overall_pure','overall_e_catalogue','overall_nb_orders_rto','overall_no_po'},

%selection_type={'selective'},

%year={'$(=MAX(%year))'}

>}values

)

Re: Data not visible for 2017

Mon, 09 Jan 2017 08:23:51 GMT

Hi Nirmala

Please make sure this returns 2017 : =MAX(%year)).

Might be a date issue or some data isnt in the database yet.

Kind Regards

Re: Data not visible for 2017

dsharmaqv — Mon, 09 Jan 2017 08:36:33 GMT

please attach your sample app. if data is present for 2017 then problem with the expression only.