topic Re: presentation issue in QlikView

presentation issue

manoranjan_d — Mon, 19 Sep 2016 12:02:19 GMT

I want to display the unit selection in the chart y axis , according to the selection in the dollar list box

example

dollar list box have

billions

millions

thousand

now when user select the value in the dollar list box it have to display in the y axis of the selected dollar list, so for this i have gave degree 270 and value in the chart presentation tab of the text in chart.

now my actual issue is these dollar value have to be displayed only in the spend amount expression and not for the presentabsent expression, these two expression are simply grouped

these can be acheived or not?

chart title to be changed

Re: presentation issue

manoranjan_d — Mon, 19 Sep 2016 12:10:29 GMT

this another issue of the chart title, now this is presntation tab issue

Re: presentation issue

Anil_Babu_Samineni — Mon, 19 Sep 2016 12:27:23 GMT

I am not fully understand your problem. Can you please explain more.

Re: presentation issue

Anonymous — Mon, 19 Sep 2016 12:41:08 GMT

create below one in the edit script

Load * inline [

dollar List, Scale

billions,1000000000

millions,100000000

thousand,1000

];

then go to your each and every expression just end of exp /Scale

like below exp

= sum({<Fact_type={'Direct'},$(=vYTD_Date),$(=vCurrent_Month),$(=vCurrent_Year)>}$(=$(Vunit))/Scale)

if user select thousand the y axis will change