In my app, I have a pivot table that looks like this:

Name    Age

Mary      10

Ann        11

Jane      12

Jack       3

John      6

Peter     5

I need to group Girls and Boys to have something like

Girls    33

Boys    14

The entire list of names is pretty long. Is there a more elegant way to write the formula then repeating if statement?

Thank you very much in advance

When I try to access Qlik Sense, I have to apply a link or translate an qr image, but I can't open my Qlik Sense environment to work, creating my apps as usually, in previous releases of Qlik Sense.

I look help and forum, but I don't get the right way to access.

I don't understand how an access layer has been added so complex that it really has nothing to do with the application, but that makes it difficult to use it.

Hi all,

In bar chart if i clicks on bar it select the bar and it filters the sheet through the value of the bar,

Is it possible to disable the selection on charts.

Thanks,

Pramod

Hello.

I am creating an app, using three qvd files.

my script is:

LOAD
    %0MATERIAL,
    %0MAT_SALES
FROM [1.qvd]
(qvd);

Load
    %0MATERIAL,
    "Corporate Reporting Group (Material)"
FROM [2.qvd]
(qvd);

LOAD
    %0MAT_SALES,
     "Local product hierarchy 2",
FROM [3.qvd]
(qvd);

I need a field, which would be a combination of  "Corporate Reporting Group (Material)" and  "Local product hierarchy 2"

I understand I need to write something like "Corporate Reporting Group (Material)"&' '&"Local product hierarchy 2" as NewField, but where and how exactly?

Thank you very much in advance

Hi Qlik experts

Need help on one use case.

Requirement: A simple bar chart with 1 dimension and 1 measure

Bar chart X axis  (Dimension) is column : Status 

(Having 3 values: Green ,Red ,Amber)

Y axis (Measure) : Distinct count of GroupID

However the measure must be such that, when GroupID has more than 1 status available, only the highest available Status is counted for.

(Red > Amber > Green)

1 Filter object on the sheet : RecordDate

Example data:

expected bar chart output (when no record date is selected):

So far I have tried FirstSortedValue,  AGGR  along with TOTAL qualifier and even Only function. It feels I am close but not yet fully there!

Thanks in advance!

Hello all:

I'm fairly new to app development, and this is my first time posting on the forums, so please excuse any errors/exclusions.

I am trying to build a table in my data model that will link to my main data table that provides unique rolling years for multiple states, along with a year index that can be used in calculations in my app. My ideal table would look something like this, with the StateQuarterCombo column being the key field that was previously calculated:

Unfortunately, I haven't had much luck with any coding I've tried so far. Would you have any tips on how I might start to construct this?

Thank you very much!

I have outer join 2 tables one as current period and one as last period.  After joining, I need to do calculation using the joined data.  May I know how I do it in script?

I have invalid expression in the below script:

[FTP]:
LOAD
Period,
"Ip Shrt Name Ith",
"Arr Lcl Num Ath",
"Global Sic Code" as t0_SicCode,
"Month, Day, Year of Glbl Trade Date" as t0_TradeDate,
"Month, Day, Year of Maturity Date" as t0_Maturity,
"Credit Grade Code" as t0_CRR,
amt as t0_Amt
FROM [lib://Loan/QS test1.xlsx]
(ooxml, embedded labels, table is Sheet1);

Outer join

LOAD
"Arr Lcl Num Ath",
Period as t1_period,
"Ip Shrt Name Ith",
"Global Sic Code" as t1_SicCode,
"Month, Day, Year of Glbl Trade Date" as t1_TradeDate,
"Month, Day, Year of Maturity Date" as T1_maturity,
"Credit Grade Code" as t1_CRR,
amt as t1_Amt

FROM [lib://Loan/QS test2.xlsx]
(ooxml, embedded labels, table is Sheet1);

[New]:
Load*,

sum(t1_Amt) - sum(t0_Amt) as Var

Resident [FTP] group by "Arr Lcl Num Ath";


Drop Table [FTP];