Hello All,

I am Trying something like below ,it is Possible to create a column with values CV,PV,ALL.

if(segment='COMMERCIAL','CV',
if(segment='PERSONAL','PV',
if(segment='COMMERCIAL' and segment='PERSONAL','ALL')

)) as SEGMENT

I know if we select both CV and PV which is nothing but ALL, ..but User specifically  need  CV,PV,ALL 

Thanks

I have a table with field

  Date(Date#("ACCTG DATE (P0045)",'yyyyMMdd'),'YYYYMMDD') as "ACCTG DATE (P0045)"

 and I want to have a field to return latest date.

I used Max("ACCTG DATE (P0045)") and get invalid expression

Hope I can get some guidance

Hi, I want to add a date picker to my dashboard. I found one in the Qlik dashboard bundle but it doesn't work. Whenever I select a date it will not filter the rest of the data on my sheet. See images attached. Do I need to do something to get it to work?

Hello all,

I'm learning to use Qlik Sense and trying to build my first app. 

I was trying to get the date from a field that looks like this:

I would like to extract the date, how should I do it having "ETC: " before the date?

Thank you very much in advance.

Hi Experts,

I have to add a Dynamic text box on below Nprinting Power point report as As of 02/04/2020.

For 02/04/2020 I have dragged vMaxReportDate variable to slide but its showing max(Report Date) expression which is the formula of variable but i am looking for 02/04/2020 as the result from that variable. Please help me on this.

Thanks in advance

Hello All,

i Need help in doing a condition enabling in a chart , in below combo chart by default i have to show as below

Dimension: YEARMONTH

Expression: 1)Prod:    Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_input)

                        2)Sale:      Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_d_op)

Combo:  

so far so good,

Now my requirement is to do a condition enabling , I have created a inline field called Category which as values prod,sale,Brand and in each expression i have added condition as shown below

Combo Chart:

Dimension: YEARMONTH

EXpression :1)   if(Getselectedcount(Category) =0 or Category='prod',

Sum({<Month,Year,Date={">=$(=date(monthstart(addmonths(max(Date),-5)),'DD-MM-YYYY'))<=$(=date(((max(Date))),'DD-MM-YYYY'))"}>}p_input)

)

Before selecting Category 

After selecting  prod from category

I am getting only Selected Year, Month prod values even after ignoring Year,Month

Kindly suggest,how to write condition in expression.

Thanks

Hello Everyone, 

I am bandari, i have just started working with qliksense. i am currently working and i am stuck somewhere and i am not finding any answer for it. 

I have 13 columns like P01,P02..P12, and KPI column. for example:

Now i will have to calculate values for every quater(q1,q2,q3,q4) depending on each Kpi value(i.e., if its 'A' then i have  just give the sum of P03 for q2, If its 'B' then it should be sum(P01+P02+P03) for q1 likewise i have to calculate P06 for q2 and sometimes P01+P02+P03 for q2). i have importe the script . but now i dont know how to proceed furthure. Please help me do this. I have a deadline by this saturday.  Please give sample querys if possible. 

Thank you so muh for your time .

Hi,

Does anyone know if NPrinting, like Qlik Sense, has a configurable timeout for the web engine?

We are experiencing an issue at a customer where a short duration of inactivity causes the users the be thrown out and needs to log in again.

In Qlik Sense there is a timeout setting for the proxy service (<add key="WebSocketPingInterval" value="0"/>) where the default value is "0" but when changed to 60 the session is kept alive.

Have anyone else experienced this and if so, how did you solve it?

BR

Daniel