Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

qlikview pivot table works on qlikview desktop but wont work on server

Hi all,

Created a pivot table with several dimessions and two expressions

the expressions are like this : Sum({<dtimport_formated={'$(TodayDate)'}>}valor_brt)

taodaydate is a variable,

The table works fine when using qlikview program in the desktop bur does not work when on the server.

the loading script also concatenates a couple of fields that are used as dimensions.

can anyone help ?

thanks

8 Replies
Anil_Babu_Samineni

How you define TodayDate

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

Load script  with :

LET TodayDate = date(today(0),'DD/MM/YYYY');


thanks

Anil_Babu_Samineni

Now, tell me not working means, How this is showing in Access point?

I've tested just now and it's working

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

al the dashboard works, the pivot talbe appears empty !

Anonymous
Not applicable
Author

is your pivot table located in a container box?

Anil_Babu_Samineni

In pivot table, How you are considering. Can you show image of Pivot table?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

what is a container box ?

Anonymous
Not applicable
Author

This one is from the server

Capturar1.JPG

and this from qlikview

Capturar2.JPG