Hi,

I need to somehow get the difference between two dates assigned to variables and assign it in a new variable, what am I missing?

QFlag:
LOAD
EmptyColumn,
DateColumn
FROM [lib://QVDFilePath/QFlag.qvd]
(qvd);

LET vData=Peek('DateColumn', 0, Timestamp(QFlag,'YYYY/MM/DD hh:mm/ss'));
LET DateNow = Timestamp(Now(),'YYYY/MM/DD hh:mm/ss');
Let vMinus = Interval(($vData- $DateNow ), 'mm');

Drop Tables QFlag;

Trace '$(vData)';
Trace '$(DateNow)';

Results: 

Thank you.

I was able to upload files to App Contents on my Qlik Sense Enterpise the day last week.

But i was given error since monday, "Error uploading file". been trying to resolve it but unable to do so.

i am able to delete files in the app content, but unable to update any files at all. Even files that i was able to do so previsouly.

Would appreciate if anyone can assist.

Hi all,

i have Ticket reported date='12/12/2023 19:23:00' and Ticket resolved date=' 14/12/2023 10:33:00'

basically operation hours start from morning 6am to 23:59pm

if we calculate time difference between will get 35.33hr's between dates. I want to exclude non operational hours which is from 12:01 AM  to 5:59 AM hours need to exclude from total hours with respective dates

Example: from reported date 37min+4 hours=4:37hr's

13/12/2023 have 24hr's operational hours=18

14/12/2023 have 10:33hr- 6hrs non operational hrs(12:01 AM  to 5:59 AM)=4:33hrs

finally total operational hours b/w dates=26.7 hr's

pls help me how can i achieve this in qliksense

Hi All,

I am creating 4 different filter panes with 4 different expressions in each. My expressions are as below
=Aggr(If(CNLevelOrder < 13, Replace(CNLevelSelect, 'No. of days', 'Days')), CNLevelSelect)
=Aggr(If(CNLevelOrder > 13 and CNLevelOrder <29, Replace(CNLevelSelect, 'No. of days', 'Days')), CNLevelSelect)
=Aggr(If(CNLevelOrder <46 and CNLevelOrder >29, Replace(CNLevelSelect, 'No. of days', 'Days')), CNLevelSelect)
=Aggr(If(CNLevelOrder >46, Replace(CNLevelSelect, 'No. of days', 'Days')), CNLevelSelect)

My requirement is to select Show CNLevelSelect values in Filterpane with some filtering condition and whatever the field value have No. of days as left characters replace with Days, for example No. of days to request ----Days to request

When I am selecting particular value from any filter other filterpanes are not showing anything and more over other data is also not affecting when selecting any value from filterpane

what could be the issue....

It would be so grateful , if anyone helps!!!

Thanks.