Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Visual misunderstanding

Hello,

I have made my first time serious app. Everything seems to be fine, but one.
I have made simple buttons to easy change interval, it is last month, this month, all, custom one from calendar object, and now and yesterday.

When I have clicked on "DZIS" what means today I had 16.01

2019-03-18_14h12_07.png

But it is only visual problem, because - even if - when I had clicked compile the choice was alright 18.03 :

2019-03-18_14h19_49.png

So, why my calendar object and input object show wrong values, than that one I choose?
How could I repair that? It's not big deal, but it would be problematic.
I have added my project below, it is nothing complicated.

1 Solution

Accepted Solutions
Highlighted
Creator
Creator

Re: Visual misunderstanding

Good idea.

When I have made changes, I saw what was wrong.
I set pattern to format characters in properties in objects :

2019-03-20_11h18_04.png

after changing to "Mixed", date in calendar and input objects, were right at last 🙂
I left format "DD.MM" only on buttons objects.
Thank you for helping me, I wouldn't find it without your guide.

View solution in original post

5 Replies
Highlighted
Creator
Creator

Re: Visual misunderstanding

I have found something.
This is the situation when i watch on date,
and after, when I click on that date.
It change right away.

2019-03-18_15h55_13.png

Highlighted

Re: Visual misunderstanding

Hi, it has something to do with date formats butI can't reproduce in a new document, it works as expected.
Dates are integer numbers where 0=30-12-1899 and each unit is one day, so 18.03 is 17-01-1900 at 00:43:12, that's why it shows 17.01 but I don't see why it keeps showing it as a date and not just a text.
Highlighted
Creator
Creator

Re: Visual misunderstanding

I tried all the ways I could imagine, to choose "today", to not only be shown correct, but reload correct too.

I tried Now(), I tried Today(), but that could not be formated.
So I tried with Date() to format, but still, it was shown like '18.01', not '19.03'.

When I add Num() in front of that, at least in input object and in calendar object - THE VALUE CAME CORRECT, but when I clicked Reload, it has different format

2019-03-19_16h01_20.png

could someone help me and tell me what I am doing wrong? Or what I have made wrong?

Highlighted

Re: Visual misunderstanding

Hi, I would try to use a variable to work as date in front end, and use another variable that uses vPlik to create the text to add as filename:
let vFileName= text(Date('$(vPlik)', 'DD.MM'));

LOAD ... FROM $(vSciezka)$(vFileName).qvd
Highlighted
Creator
Creator

Re: Visual misunderstanding

Good idea.

When I have made changes, I saw what was wrong.
I set pattern to format characters in properties in objects :

2019-03-20_11h18_04.png

after changing to "Mixed", date in calendar and input objects, were right at last 🙂
I left format "DD.MM" only on buttons objects.
Thank you for helping me, I wouldn't find it without your guide.

View solution in original post