Hello i'm trying to create a field which will "predict" shop monthly revenue based on current average revenue. In other words im taking revenue from current month and divide it by days that have already passed. Then im multiplying this number by number of days that there are in month.

So it look like this :
((Sum({<[channel]={'ABC'},Yearx={'2022'},[Monthx]={'May'}>} [Revenue]))/(day(today())-1))*31

So as you can see i have put manually year, month and number of days in a month. i would like to automate this so i won't have to change it every month 🙂

But i cant figure it out

I've tried with [Monthx]=month(today()) but it doesnt work...

Hi:  Has anyone figured out how to integrate DUO, which is SAML standard, to Qliksense SAAS, as IDP/SSO?

Or is it just impossible because QS only support OIDP standard ? 

We have DUO already and don't want to adopt something else unless we absolutely have to

thanks for any info,

Don

Hello community

I'm facing an issue about add many measures on the radar chart (bundle vizualisation)

we can only put 1 measure...

we cannot realise the same viz like qlikview ( in order to show benchmark for example)

Is there a tips in order to realize real Radar Chart?

Tanka a lot

Within Qlik Sense Hub, I am trying to create a YYYYMM table to link to several other tables. However, I cannot seem to get the data types to align between tables so when I try to connect on this field, the connection seems poor. Both fields are coming from imported excel files and I have reviewed the fields in each file several times to ensure they are the same within the underlying excel. I don't understand why Qlik left justifies one column but right justifies the other column (see screenshot).

Any help on how to get these fields to align with each other is greatly appreciated.

Hi team,

I would like to get the field "Cumulative cost"

Do you have some idea? I would like to have it inside of the script.

Thank you very much,

Hello!

I import data in te following form:

I would like to create a chart/table as the following:

Any idea of how I could do this?

I have a problem creating a Set function for accumulating all valaues up to the selected filter (Year, Month, Date).

My aim is to SUM all values and display them in a bar char (drill down year, month, date).

The values should be summed up to the max selection.

For example: if year 2022 is selected, all values before 31.12.2022 summed up.

Hello!

I want to get a table chart in which I will see the following: partner, keyword, number of customers, percentile (which percentile corresponds to the number of customers for this keyword inside the partner in the row).

I understand that I need to use a fractile to calculate percentiles in qlik sense, but I have not yet managed to figure out how to get a fractile to express the number of customers within a partner group for my table.

Thanks in advance for any tips for this!