Help me in displaying the data on barchart? - Qlik Community

durgabhavani · ‎2015-09-11

Hi All,

Help me in displaying the latest 10 dates and values in chart?

Please find the attached application.

Thanks,

Durga

sunny_talwar · ‎2015-09-11

Hi Durga,

Is there anyway you can share the data in your qvw file? I am working with Personal Edition of QlikView and won't be able to share what you have shared?

Best,

Sunny

vikasmahajan · ‎2015-09-11

PFA and setting.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

durgabhavani · ‎2015-09-11

sunny please find the attachment.

tresesco · ‎2015-09-11

PFA

durgabhavani · ‎2015-09-11

Vikas,

I dont want to display other values apart from 10 latest dates on chart.

please advice

vikasmahajan · ‎2015-09-11

you mean to say top 10 values ???

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

durgabhavani · ‎2015-09-11

tres, what changes you made to app

durgabhavani · ‎2015-09-11

No Vikas, Latest 10 dates from today to back.

tresesco · ‎2015-09-11

Created a variable:

vTenthDATE=Max(DATE,10)

Then in the group, edited the DATE field to expression: =If(DATE>=vTenthDATE, DATE)