Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Have u tried using single expression in a text object to see if it is displaying any value
Example: Sum(Val) or Sum({$}Val)
Have u tried using single expression in a text object to see if it is displaying any value
Example: Sum(Val) or Sum({$}Val)
Are all the field still available in your application? Did you install a new version of QV? Can you share more details
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).
Sorry, but i found solve this issue because i forget to select the table 'Period' 😕
Thanks a lot them