topic Re: Error on Set Expresion in QlikView

Error on Set Expresion

Anonymous — Fri, 08 Apr 2016 15:31:34 GMT

Hello,

I am a beginner on QlikView and i don't understand why my Pivot table doesn't show the data.

For some reason i had to reinstall Qlikview in my Desktop and now my data are not available.

Here my expression in my Pivot Table:

IF(Period = 'YTD', SUM({$}Val),

IF(Period = 'MTD',SUM({$}Val) - Sum( {$<AsOf = {">=$(=Num(AddMonths(Max(AsOf),-1))-5)<=$(=Num(Date(AsOf, 'DD/MM/YYYY'))-5)"}>} Val)))

It works before, may be it is due to a setting on QlikView ?

Thanks in advance for your help,

Sébastien.

Re: Error on Set Expresion

satishkurra — Fri, 08 Apr 2016 15:33:46 GMT

Have u tried using single expression in a text object to see if it is displaying any value

Example: Sum(Val) or Sum({$}Val)

Re: Error on Set Expresion

sunny_talwar — Fri, 08 Apr 2016 15:34:17 GMT

Are all the field still available in your application? Did you install a new version of QV? Can you share more details

Re: Error on Set Expresion

swuehl — Fri, 08 Apr 2016 15:34:28 GMT

Have you checked that AsOf field shows a numeric representation? I mean, that it has been coorectly interpreted as date, i.e. date interpretation is working (e.g. check default date format).

Re: Error on Set Expresion

Anonymous — Fri, 08 Apr 2016 15:38:06 GMT

Sorry, but i found solve this issue because i forget to select the table 'Period' 😕

Thanks a lot them