Hello Community,

I have many tables and each table contains a date field. I want to create one calendar but idon't know if it's possible with many dates. Is there a way to create measures and in the set analysis i refer to the exact date  that i want? and should i create many calendares or just one which is disconnected from the model?

Thanks in advance

Hi All,

I  am facing issue at Set analysis to get previous quarter [max(Quarter)-1] data when we select Quarter [max(Quarter)].

I have data format (YYYYMM) from that I derived Year (YYYY), Quarter(Q1) and  YearQtr (YYYYQ like 20191..) fields.

Written expressions in chart as below:

Sum({<YearQtr = {$(vPreviousQtr)}} Sales) - tried single, double and no quotations at variable.

VPreviousQtr = If(Right(YearQtr) = 1,  YearQtr-7, YearQtr-1) = It will show previous quarter.

And I tried with "autoCalendar" as well to get date fields.

I used "QuarterAgo" field in set analysis instead of YearQtr which has Quarter Numbers (starting with 0 like current quarter is '0'.

App has only Year and Quarter filters to select by users.

With above to ways i could not get previous quarter data by selected Quarter [max(quarter)].

Could you please assist with if you have any idea.

Thanks, Nihhal. 

Hello!

I am stuck on the following problem.

I have a dimension called Name. The same name can have several different dates attributed to it. I want to make a table/chart that shows the list of all names and a column next to it specifying whether ANY of the Name's dates are within a predefined period.

For instance, if "John" has 3 dates - 05.12.2019, 06.12.2019, and 12.12.2019, and the specified period criteria is of range 10.12.2019 - 31.12.2019, then I want to show "Yes" next to John's name.

I made a simple solution that does this, but for each date separately, repeating the names. I, however, need each name to be showed only once in the column if any of its dates match the date criteria.

Thank you in advance!
Ray

Hi,

We have added a third consumer node to Qliksens cluster. We have run repository service and engine service on it. The services are showing to be running fine in QMC

However, out of the three consumer ndoes, the third one is not showing any activity. 

How can I test that the third node is working fine and the reports being opened on that node are delivered without any issue?

Regards

Hi Team,

I am using filter pane which has list of all countries.When i click on a particular country eg. 'India' list of cities which belongs to India must be shown as a drop down without using another filter pane. Attached is the sample snapshot of the requirement.

Please assist me in solving this issue.

Thanks

Hi,

I am trying to create an NPrinting PPT report. 

When dragging a chart as image on the slide I was able to see a preview of my exact chart in older NPrinting versions.

With version 19 I can only see kind of like a placeholder (like attached) but not the real chart from Qlikview anymore. 

Is there some way to resolve this, as it would make creating slides much easier?

Thanks

Hi,

I would appreciate some help with a simple question, that I am struggling to fix.

I have a straight table with two calculations in column(1) and column(2).  I would like to only show records where column(1)-column(2)=0

Regards,

Daniel

Hello

We have a common problem.  When I copy an app on the server from one folder to another, or sometimes even just closing a report on the server, the copy takes a long time like half an hour or when i close an app i get not 'responding'.

I'm not sure if there is a process running that prevents me from saving qvw. When a qvw runs does it prevent you from saving on the server?

Has anyone experienced issues like this

Many thanks

Paul

Hi,

I have requirement to get the data from two different tables and table-1 is located in server-1(Mysql) and table2 is located in server-2(mysql). So trying to connect both servers at a time but its not happening. if one server is connected then other server is getting disconnected.