topic Re: cross table reflecting charts in QlikView

cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 08:46:35 GMT

Hi All ,

i got this problem after using this CROSS TABLE function, before using that function my chart displayed data but after using this function there are showing no data to display,even though the expression i wrote in both the charts has nothing to do with this cross table fields,but still i am getting this problem.....the problem is with sheet1 and sheet2 looks ok .....

can any one help me plz, plz find the attachment

Re: cross table reflecting charts

Kushal_Chawda — Fri, 15 Apr 2016 08:48:39 GMT

I am not able to open QV can copy paste the script?

Re: cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 08:50:22 GMT

what do u mean is my file got corrupted or u got personal edition

Re: cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 08:56:30 GMT

can any help regarding this requirement plz

Re: cross table reflecting charts

Gysbert_Wassenaar — Fri, 15 Apr 2016 08:56:55 GMT

Try this expression:

=Aggr(FirstSortedValue(distinct {<ROLE={'EVAL'},SUPCAT=,QUATERS=,YEAR=,name1=>}SUPCAT, -DATE_OF_REVIEW), name1)

Re: cross table reflecting charts

Kushal_Chawda — Fri, 15 Apr 2016 08:57:16 GMT

I don't have QV in my system

Re: cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 09:00:39 GMT

where should i try this expression ,i mean in my above pie chart or below in straight table?

Re: cross table reflecting charts

Gysbert_Wassenaar — Fri, 15 Apr 2016 09:02:12 GMT

In the pie chart. Just add DISTINCT to every FirstSortedValue expression in both charts.

Re: cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 09:04:45 GMT

i did so, i am getting nothing out of it, just copy pasted your expression

Re: cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 09:06:18 GMT

r u working on my file ,if so will u plz send it to me

Re: cross table reflecting charts

Gysbert_Wassenaar — Fri, 15 Apr 2016 09:06:43 GMT

See attached qvw.

Re: cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 09:09:41 GMT

Is it same file that i attached earlier

Re: cross table reflecting charts

Gysbert_Wassenaar — Fri, 15 Apr 2016 09:10:47 GMT

No, I modified it.

Re: cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 09:12:26 GMT

ya ,but u worked on my file itself , the one i attached earlier

Re: cross table reflecting charts

Gysbert_Wassenaar — Fri, 15 Apr 2016 09:14:37 GMT

yes

Re: cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 09:45:41 GMT

It worked out man,thanks for your help......i need a one more help from you , i known i should open a new thread but his problem is related to the same file i attached ,the thing is ,i have given rating for each supplier based up on there total score in an excel sheet at script level,

so what i am looking is on selecting each supplier category rating i need to display there respective supplier in the table,

but the problem over here is it should take in to consider only auditor current score ,

what i mean is i should able to see this supplier only if i select 'B' rating from supplier category but now it is considering under A rating ......i mean my selection should only effect auditor current score column

Re: cross table reflecting charts

Gysbert_Wassenaar — Fri, 15 Apr 2016 09:53:04 GMT

Well, you know where the set records selectors are. You put them in the expressions yourself, right? If you want the expressions to take the selections into account the remove the filters from the set analysis expressions again.

Re: cross table reflecting charts

kunkumnaveen — Fri, 15 Apr 2016 10:09:11 GMT

the expression i wrote in the table is:

1)Self Evaluator Current Score:

FirstSortedValue(distinct {<ROLE={'SELF_EVAL'},MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

2)Auditor Current Score:

FirstSortedValue(distinct {<ROLE={'EVAL'},MaterialName=,Category=,Decision=, ENSTEHDAT = >}TOTAL_SCORE, -DATE_OF_REVIEW)

so which filter should i need to remove to make my selection effect only on second expresion, I mean the table should display the supplier names based up on rating selected, considering only 2nd column