Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
cocalero
Creator
Creator

Error on Set Expresion

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.

1 Solution

Accepted Solutions
satishkurra
Specialist II
Specialist II

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

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

View solution in original post

4 Replies
satishkurra
Specialist II
Specialist II

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

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

View solution in original post

sunny_talwar

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

swuehl
MVP
MVP

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).

cocalero
Creator
Creator
Author

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

Thanks a lot them