Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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)

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

Anonymous
Not applicable
Author

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

Thanks a lot them