topic Re: Logic in QlikView

Logic

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

Hi Expertise Need help ,

Please find the attachment of the QVW file

I have a slider ..

My requirement is like

If i slect any number say 9.38 then the table chart should show me the values related to 9.38 and above it till 10 ..

Basically i need the range ...

and if i select the slider at 9.96 then the table chart shoul show me the data releated to 9.96 and above ..

how can i achive this ?....

Neex suggestion

thanks in advance....

karthikoffi27se — Wed, 21 Feb 2018 07:27:15 GMT

HI John,

You attachment is already showing the value what are you looking for, can you explain little in brief.

Many Thanks

Karthik

smilingjohn — Wed, 21 Feb 2018 07:43:17 GMT

Hi Karthik ..

Look in the QVW file i have attached .. i have made the selction on slider which is 9.38

and if you look into the table it is displaying me the value with that perticular ID ..

What i want is when 9.38 is selected the table chart should show the values and id's starting from 9.38 till 10..

and if i select 9.86 then the table chart should diplay all th ID's from 9.86 and above till 10 ..

I hope you did understood ..

Tahnk s

kevinalvino — Wed, 21 Feb 2018 07:47:07 GMT

Hi John,

If i'm not mistaken at understanding your request,

Please take a look at the attachment

FYI, i'm using a straight table because as i know, you can't put calculated dimension in a Table box.

Best Regards,

Kevin

Anil_Babu_Samineni — Wed, 21 Feb 2018 11:00:56 GMT

Table box won't calculate that, So, Create straight table and use something like below for metric?

sum({<[Field Name] = {"=[Field Name]>=Sum([Field Name])"}>} [Field Name])

smilingjohn — Wed, 21 Feb 2018 12:39:09 GMT

Hi Anil..

This is not working

When select any range in the slider the straght table is showing the data to only tahat perticular number ..

I want to show the slected number in the slider as well as all the number after that selction ..

Anil_Babu_Samineni — Wed, 21 Feb 2018 17:02:06 GMT

Bit busy. Let's see stalwar1‌ will offer something for you?