topic Re: table is not showing all data within a dimension in QlikView

table is not showing all data within a dimension

Tue, 02 Aug 2016 19:44:48 GMT

Hello,

I am new to Qlikview and trying to solve this issue.

I need to create a table with two columns, first column is each person's name, and second one is hours per month, which is derived from a calculation in the expression tab:

=IF(TODAY()>[Opp Exp Decision Date], ([Local Member Firm Fees]*[Opp Probability]/100)/295*0.5,[Local Member Firm Fees]*[Opp Probability]/100/295)/IF(((([Opp Est Eng End Date]-[Opp Est Eng Start Date])/30)=0),1,([Opp Est Eng End Date]-[Opp Est Eng Start Date])/30)

However, the result is not showing everyone's hrs/month, it's only showing few of them. what kind of issue is this? How can I make sure everyone's name is included.

Basically, my end goal is to create a hrs/month column which results from few of the raw data fields by writing a calculation script in the dimension field, based upon each person's name, or if you have better way please advise.

Can someone help me on this? Thanks!

Re: table is not showing all data within a dimension

Frank_Hartmann — Tue, 02 Aug 2016 20:24:37 GMT

Can you upload a small sample with reduced and obfuscated data?

Without knowing your script and expressions it will be hard to assist

Re: table is not showing all data within a dimension

Tue, 02 Aug 2016 22:31:56 GMT

Hi,

The straight table only picks up distinct value but not the repeated value. As an analogy, if there are three "Rosanna" under name columns with three different ages, straight table only picked up one of the ages since the name Rosanna is a repeated data field.

The problem was fixed once I put another dimension, as an analogy, if I add another column of data field "Rosannas' hobbies" within the properties' dimension, which are singing, driving, traveling, then the table displays all data fields pertaining to Rosanna and their three ages.

I want to be able to show all of the data field relating to Rosannas and their ages, but not with the inclusion of their hobbies.

Thanks!

Re: table is not showing all data within a dimension

Frank_Hartmann — Wed, 03 Aug 2016 08:25:13 GMT

i think you will get help much faster if you upload a small sample

which describes your problem in real sitiation.

QlikCommunity Tip: How to get answers to your post?

Re: table is not showing all data within a dimension

Kakay_Ranas — Wed, 14 Aug 2019 18:33:22 GMT

I am having this same problem. Under 'MEASURE', each 'CONTRACT' may have 1 or 2 measures but only those with 1 are showing in the table. Other contracts with 2 measure are blank under 'MEASURE'

MEASURE = MEASURE

CONTRACT=If(Match(CONTRACT, 'HP_SCCAREFIRST'),'CAREFIRST'
,If(Match(CONTRACT, 'HP_CAREFIRST'),'CAREFIRST'
,If(Match(CONTRACT, 'WINDSTREAM COMM'),'WINDSTREAM'
,IF(MATCH(CONTRACT,'ANTHEM','SHBP','STATE OF OHIO', 'HIGHMARK', 'WALMART', 'BCBSMN', 'CITY OF CHICAGO')
,IF(WILDMATCH(UPPER(MEASURE),'CS_CALL_ABANDONMENT', 'CS_SERVICE_LEVEL'), CONTRACT)))))