topic Re: How to display Comment as Text Data Only ? in QlikView

How to display Comment as Text Data Only ?

Mon, 09 Sep 2013 07:26:09 GMT

Hi All,

I have this set of data in my Qlikview:

I only want to display Q3_Comment, Q4_Comment Group by EOR_Subject, EOR_Questions.

Result that I desired:

Questions:

1) What charts should i use for text only data ? I tried Straight table and pivot table but to no valid.

2) How to show only specific questions only group by Subject and sorted by questions. It seems that Pivot table should do the job but I am stuck at the expression part as there is no measure to be used as Data is text only.

3) How to omit the Q3_Comment, Q4_Comment that has NA, -, N/A, empty all at once ?

Thanks in advance.

Re: How to display Comment as Text Data Only ?

amars — Mon, 09 Sep 2013 07:36:21 GMT

Use an expression like the below:

IF(WildMatch(EOR_Questions,'Q3_Comment','Q4_Comment')>0,'')

in your pivot. Keep the header of ur Expression as a single space value and it will do the thing.

Thanks

Re: How to display Comment as Text Data Only ?

Gysbert_Wassenaar — Mon, 09 Sep 2013 07:49:17 GMT

By far the easiest way is to add a listbox for the EOR_Questions field and then select in that listbox only those values you want to see the results for.

If you only want to show text values you can try an expression like: if(isnum(Data),null(),Data)

If you want to omit some values too you can try: if(isnum(Data) or match(Data, 'NA','N/A','-'),null(),Data)

Re: How to display Comment as Text Data Only ?

Thu, 12 Sep 2013 01:57:35 GMT

Hi All,

Thanks for your help, manage to get this done with WildMatch expression. Below is the answer to it.

=If(WildMatch(EOR_Questions,'*27*','*28*','*29*')>0 ,EOR_Questions)

Warmest Rdgs,

Chun Wey