Discussion board where members can get started with Qlik Sense.
I have 5 dimension and a calculated month,year and quarter field like this.
Year($(vDate)) as Invoice_Year,Month($(vDate)), 'MMM'),'MMM')) as Invoice_Month,DUAL('Q' & Ceil(Month($(vDate)))/3) & '-' & Year($(vDate))) , QUARTERNAME($(vDate)))) as Invoice_Quarter,
Invoice_Quarter, Invoice_Month,Invoice_Year are filters.
In my table i have set calculation condition to
getselectedcount(dim1)>0 or getselectedcount(Dim2)>0 or getselectedcount(Invoice_Month)>0 or getselectedcount(Invoice_Quarter)>0 or getselectedcount(Invoice_Year)>0 .
Problem is, in straight table i'm getting values whenever one or more selections is made in Dim1 or dim2 or month.
But when i select any one filter in quarter and year, the table remains blank.
Can any one help me to tackle this problem.
Is there any alternative for this.
In the data the year is only 2017 and quarter is Q1-2017,Q2-2017,Q3-2017 and Q4-2017.
Would you be able to share a sample where we can see the issue you are facing?
I could have, but i'm working on server side. Moreover data is around 15M records. Even if i downloaded to local, it is taking time to get the connection.
@sunny_talwar please find the attached sample. Please look into the calculation condition in table, for invoice# i'm getting the values, for month , quarter and year table is not populating
Where u able to look into it? Please can anyone provide me the solution. I'm stuck in this.