topic Re: how to display fields values in QlikView

how to display fields values

kunkumnaveen — Thu, 14 Jul 2016 15:46:05 GMT

Hello All,

A kind of wired thing is going on with my dashboard,the thing is ,the thing which was working great before reload was not working ,anymore after reload

this is how my dashboard look,3 charts

Dimension:1) LOCATION,

2)LocationQuality

expression:

firstsortedvalue(distinct {<Category=,Decision=,ROLE=,SUPCAT=,YEAR=,LOCATION=,name1=,ENSTEHDAT=,MaterialName= ,LocationQuality={QUALITY_GOV } >} Value, -ADATE)

so on click on any of these three chart ,it used to get select both dimension values,i mean this

After going a reload i got new LOCATION data in to dashboard ...

so on click on any of these three charts, only LOCATION is getting selected but not LocationQuality any more,even though i have same

dimensions and expression

it working fine if i promote and demote dimension i mean

Dimension:1)LocationQuality

2) LOCATION

but i want it to work when dimensions are:

1)LOCATION

2)LocationQuality

PFA....

plz any suggestion ..thanks

Re: how to display fields values

kunkumnaveen — Fri, 15 Jul 2016 08:52:56 GMT

Hello All,i am still looking for any help or suggestion for the above requirement ..plzzzz

Re: how to display fields values

Anil_Babu_Samineni — Fri, 15 Jul 2016 09:29:32 GMT

Naveen, I don;t have the access. Can i know the dimension

Are you using any Calc dimension for Location

If yes, Please sahre me the Calc expr

Re: how to display fields values

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

Hi Anil,

Among two dimensions one is a calculated dimesion

Dimension:

1)if(not match(LOCATION,'CLOSED'),LOCATION)

2)LocationQuality..(i got this filed by applying a cross table function at script level)

Re: how to display fields values

kunkumnaveen — Fri, 15 Jul 2016 11:22:53 GMT

Will it going to make difference if we use calculated dimension as dimension

Re: how to display fields values

Peter_Cammaert — Fri, 15 Jul 2016 11:36:05 GMT

Apparently, your set analysis forces the single value-dimension 'LocationQuality' to go into hiding. Check it out: eliminate the LocationQuality dimension. Nothing will change.

And this only happens in graphs, not in table charts. If you change the chart type to Straight Table, two dimension columns will appear, and clicking on the value will select values in both dimensions.

I think this is default behavior. You can try turning this series of charts into a Trellis setup (with LocationQuality as Trellis dimension). That will allow you to select the two dimension values.

Best,

Peter

Re: how to display fields values

kunkumnaveen — Sat, 16 Jul 2016 06:21:32 GMT

Hello All,

i got struct at this requirement from last three days ,i have no clue wants going wrong .can any one help me plz