I have month and column values such as:

and so on..

Now I want to add a 3rd column that has values like:

and so on...

How do I add this third column QMonth.

Thanks!!

//ODBC connect to the Customer iseries client 32 bit using QLIKV user id 113019
ODBC CONNECT TO CUSTOMER (XUserId is HefFdIRJJaSMVPA, XPassword is dSMfCJNGECWGDJBKSBUML);

I have to reset this profile's password which I know where to do that but how do I encrypt/hide this information again.  I remember something about copying the string to notepad and then there is a special character or word needs to be put to make it view this way. 

can anybody help.

thank you 

Hi All

I have below expression not working fine :-

if(GetSelectedCount([Pls select 901st Dim])<1,
Money(

Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
,
$(vMoneyFormatK)),
Money(
fabs(
Sum(Aggr(SUM({<year = {"$(=Max(year)-0)"},month={"<=$(=Max({<sales = {'*'}, year = {$(=Max(year))}>}month))"},$(ColumnDim901)={$(ColumnDim901)}>}Amount*1)/$(Columndim89)/1000, $(ColumnDim108)))
)
,
$(vMoneyFormatK))
)

Hope some can advise me.

Paul

Hello all,

Need your expertise and advise. I have a table that shows the below transactions. We wanted to calculate the number of recordID and their queue time. But for a duplicate record (possibly transferred transaction), we wanted to get the earliest record only. 

I tried count distinct RecordID, but with the other Dimensions not the same, it still counted as 2 record.

Appreciate your help on this. 

Dear All,

I could not find a solution for this problem. I hope somebody can help me.

I have a formula in a table:

sum({<UnderwritingYear={'2005','2006','2007','2008'}>}[Premium])

If I now select in the table dimension only 2006, the table does not change.

How can I exclude/include in a formula values, but still be able to select/unselect values by clicking on a dimension or make a selection on a list box?

Many thanks.

Jan

Hi everyone, 

I have a data model having two fields "CustomerName" & "Customer", the two fields hold the same data but are not linked and i cannot link them due to other considerations in my data model.

i want to transfer user selections from one field to another. for example, user selects XYZ and ABC in "CustomerName", i want XYZ and ABC to be selected in "Customer" field.

I know its possible with getselections in QlikView but cannot get it to work in Qlik Sense.

your help is appreciated,

Thanks

Hello There,

My concern is how to get the updated data and if no update gets the previews data.

sample data:

I try this expression but the output its not working base on the output I need.

If(len(A)>,A,If(len(B)>,B))

The output should be that I need is like below:

Is there any other way for this kind of concern?

Best Regards,

Bing