Dear Friends,

I have a dimension field(Month_Year) in my pivot table. I have some calculation based on measures. (shown below)

here what I want is when I select a particular Month_Year in my list box   preceding 12 months  of the selected Month_Year  should appear in the columns like shown above  Eg. When I select Jun-2019 above months should be in columns. Since I am unable to modify the Dimension (Month_Year) to obtain the above output I kindly seek your help

Hi,

I wish to understand how the Rank function actually works.

In the table "Ranking" in attachment, I wish to get the top 5 Organization and displays the count of the top 5 in a KPI object.

My set analysis to get the top 5 and compute the total number of Tickets is as follows:

=Count({<Organization = {'=Rank(Count(Ticket))<= 5' }>}Ticket)

Logically I should be getting 10 as result (3+2+2+2+1), but I fail to understand why the set analysis returns 9!

FYI: top 2 to top 13 results in 9

As from top 14, result is 31

Thanks to advise on this issue

Hi,

Me and my team is trying to create a dashboard for our current project. I have a tabbed container object to show two types of data in the same object. However, I'm having issues as below:

1) When one object tab is clicked, other object will be blank:

 From the picture above, I clicked 'Risk' tab on all object, but table object for 'Risk' does not show the 'Risk' data.

2) Is there any way to allow auto filtration of data for every object? For example, if I click 'Risk' in one of the object, then all other objects are automatically filtered by 'Risk'. This is because, our current tab need to be clicked manually on all 3 objects whenever we want to view a specific data. 

Thanks.

I have a table fact table that has branch id and sales amount, I want to see the sales value of all branches against the branch I selected.

Fact Table

BR_ID, Sales

Dimension Table

BR_ID, BR_Name

Hi guys,

I have the code as below:

Newone:
SET DateFormat='DD.MM.YYYY';
Let vStartDate = Date(today()-8, 'DD.MM.YYYY');
Let vEndDate = Date(today()-2, 'DD.MM.YYYY');
LOAD
Date([SalesDate]),
[Index],
[Item],
if("[Quantity]">0, "[Quantity]"*-1, "[Quantity]"*-1)
Resident [June_sales]
where [SalesDate] >= vStartDate and [SalesDate] <= vEndDate;
Drop Table [June_sales];

I get the comment that field vStartDate is not found. What is wrong with this code?

Hi Team,

We are facing issue in QMC. When clicked on QVS we are getting error "Failed to contact QVS. make sure that the qvs is available with the correct credentials "

And not able to view folder Tab in QVS. and also User document folder is not accessible. but access point and scheduler is working. kindly help on this issue.

Hi experts,

Can anyone tell me how to adjust the below expression so that 'Pass' is green and 'Fail' is red?

=IF(Count({<SLAMet= {'Yes'}>} SLAMet)/Count(SLAMet)>.98,'Pass','Fail')

Thanks!

Hi,

I have Table 1 load from QVD and I would like to load value from Oracle connection where exists from Table 1.

Table1:

Load 

DOC_ID,

DOC_ID AS DOC_ID_DUPLICATE

FROM LIB://.....QVD;

Table 2:

LIB CONNECT TO 'DB';

LOAD DOC_ID,
STAMP_UID,
;

SELECT "DOC_ID",
"STAMP_UID",
FROM "BASW_PROD"."ACTION_LOG"

WHERE EXISTS (DOC_ID_DUPLICATE, DOC_ID);

Could you please help?

Thanks