Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have got pivot table in my dashboard in qliksense . Below is the image of dashboard .
My expression :
For Row1 - Count({$<[UW_MONTH_KEY] = {"$(=$(vMaxUWMonth))"},POLICY_STATUS={'Active'}>} DISTINCT POLICY_NUMBER)
Row2 - Count({$<[UW_MONTH_KEY] = {"$(=$(vMaxUWMonth))"},POLICY_STATUS={'Cancelled'},POLICY_CANCELLATION_DATE_YearMn = {"$(=$(vMaxUWMonth))"}>} DISTINCT POLICY_NUMBER)
Row3 - Count({$<[UW_MONTH_KEY] = {"$(=$(vMaxUWMonth))"},CLAIM_STATUS_FINAL={'OPEN'} >} DISTINCT CLAIM_NUMBER)
All the expression is working when a partner is selected. in image 2.
How can the expression work even if the partner is not selected and works when selected by user.
Thanks in Advance.
All 3 expressions don't work without selection? In general, you might need to use Aggr() with if statement instead of using set analysis to make this work.
I am tried to import less data and make a sample model. Please can you assist me in the expression to use if and Aggr().
Why can't the set analysis work with dimension ?
I think you forgot to answer my first question, are all the three expressions not working? I guess what will really help is to know what is the output you are hoping to get?
Also, right now when I don't have RECORD_SOURCE_NAME selected or not selected, I am getting the same number. Can I see the problem in the attached sample?
Hi Sunny ,
All the expression is not working when no selection is made i.e when no RECORD_SOURCE_NAME is selected.
I just gave first three as sample example as I got many expression.
My output pivot table should work for no selection of RECORD_SOURCE_NAME or when selected.
The sample model is reflecting correctly with or without selection.
But the original model is not working correctly. My original model is around 576 MB
Not really sure how to help if I can't see the problem 🙂