Hello, 

Has anybody used autocalendar derived fields in Set Analysis with Alternate State?

The following senteces does not work and to me it is bizarre it does not:

Sum({<[OrderDate.autoCalendar.Year]=Stato_A::[OrderDate.autoCalendar.Year]>}Sales)

Thanks, 

Umbi

I'm trying to create a bar chart that changes variable factors by filter selections.

With ID of A, B, and C, I want to compare two selected factors' sum

like  A&B sum by date,   A&C sum by date , or B&C sum by date as below.

But the first issue I'm facing is sum({$<ID={'$(GetFieldSelections(ID))'}>} Unit) does not bring sum unit into the graph, even though KPI shows the selected factor. 

Then the second issue is that how can I apply two selections into that one bar chart? 

data is as below.

original:
load * inline [ Date, Week, ID, Unit
9/1/2021, 1, A, 1
9/1/2021, 1, A, 2
9/2/2021, 1, A, 1
9/2/2021, 1, A, 2
9/2/2021, 1, C, 2
9/3/2021, 1, A, 1
9/4/2021, 1, A, 2
9/5/2021, 1, A, 2
9/6/2021, 1, A, 2
9/7/2021, 2, A, 3
9/9/2021, 2, A, 3
9/9/2021, 2, A, 3
9/9/2021, 2, C, 3
9/3/2021, 1, B, 1
9/4/2021, 1, B, 2
9/5/2021, 1, B, 2
9/6/2021, 1, B, 2
9/7/2021, 2, B, 3
9/7/2021, 2, B, 5
9/7/2021, 2, C, 5
9/9/2021, 2, B, 3
9/10/2021, 2, A, 3
9/14/2021, 3, A, 2
9/10/2021, 2, B, 3
9/11/2021, 3, B, 2
9/12/2021, 3, B, 2
9/13/2021, 3, B, 2
9/13/2021, 3, B, 4
9/14/2021, 3, B, 2
9/27/2021, 5, A, 2
9/28/2021, 5, A, 5
9/15/2021, 3, B, 2
9/15/2021, 3, B, 3
9/16/2021, 3, B, 2
];

Hi Community,

I have two tables, Revenue and Budget, I have to calculate MTD for both Revenue and Budget

My Revenue max month November and the budget month is December,
But what is the maximum month in Revenue, the maximum month should show the same even in the budget.

(if it is oct in Revenue, Budget should be OCT value)

Based on user selection value should be change..

and YTD also should be same..

Thanks in Advance!

whenever i add levels based on the year ,why the year is displaying for first row and not for entire rows ...any solutions???

This problem is for both excel and HTML reports

I attached the sample image for your reference

I have 2 sets of data that I need to chart using scatter chart. The only problem is the X-Axis values are different for the 2 sets of data. How can I specify different X-Axis for each Y-Axis data? I appreciate your help. Thanks

Hi Team,

I have created a straight table where it shows the expression for all but the dimensions are invisible.

What does it mean, are they unmatched data?? Or I am i going wrong somewhere. 

please reply me ASAP..

Hi, I want to calculate time difference in hours and try to convert an SQL Logic to use in Qlik Sense

SQL:

DATEDIFF(minute,convert(datetime,RECEIVEDON,104),COALESCE(CONVERT(datetime,SUpdatedOn,104),CONVERT(datetime,SDATE,104)))/60

My statement in QlikSense:

(Coalesce(Date(SUpdatedOn),Date([SDATE]))-(Date([RECEIVEDON])))/60 as Time_Taken

On doing: Date([SDATE]))-(Date([RECEIVEDON]))/60 as Time_Taken, I am getting value same as in manual calculation

I am getting different values than manual calculation on using this, If I don't use coalesce value is same. Let me know how can I correct it or some other way to achieve this.

@Suraj @mvpacker @lebronjames23 

Hi Experts,

I am new to the Qlik sense I want to use to measure slicer selection filters and calendar type of filter, how can we create in qlik sense those like below is an example ones. is it possible to do in Qlik sense if yes , please provide detail examples or any video or file give me. 

also what different kind of selection filter were there in qlik sense.